zzz projects Dapper Tutorial
Getting Started Documentation 3rd Party Libraries Knowledge Base Online Examples
  • Getting Started
  • Documentation
  • 3rd Party Libraries
  • Knowledge Base
  • Online Examples
  •   Download  

Dapper Tutorial - Knowledge Base (KB)

17 results for: in tag: asp.net-mvc-4

Dapper class vs. dll?

What are the pros/cons of copying Dapper.cs into my project vs. using the dll instead vs. installing the nuget package?...This is an MVC4 project if that matters.
asp.net-mvc-4 dapper
asked by r.l.parker

DapperExtensions DefaultMapper not working

I am having following code...class Program { static void Main(string[] args) { static void Main(string[] args) { DapperExtensions.DapperExtensions.DefaultMapper = typeof(CodeCustomMapper); string sql = "select UserID,Name as SName , ...
asp.net-mvc-4 dapper
asked by Gaurav Moolani

Dapper.net how to create a map

public CodeCustomMapper() { Map(f => f.Name).Column("SName"); Map(f => f.Name).Column("TName"); Map(f => f.EmailID).Column("wmail"); Map(f => f.EmailID).Column("Email"); } ...I want create this kind of map for dapper.query function....
asp.net-mvc-4 dapper
asked by Gaurav Moolani

Dapper Cannot find open Connection MVC3

I've recently created a new project in MVC3 and connected a MySQL db to it without a problem. I'm able to create users and roles (using Universal Providers / SecurityGuard from NuGet). Now I'm trying to run a query using Dapper for my Edit page and get ...
asp.net-mvc-3 asp.net-mvc-4 dapper mysql
asked by Gary James

Is there a way to remove the default dependency on Entity Framework within MVC 4?

Is there a way to remove the default dependency on Entity Framework within an ASP.NET MVC 4 project and replace it with another similar technology such as ...Dapper
asp.net-mvc-4 dapper entity-framework
asked by Mantzas

Dapper - Object reference not set to an instance of an object

I've recently been playing around with dapper, but I've run into a bit of a problem regarding getting data from other tables....My database has two tables, Users and Post. I've created two classes for these tables....My User class... public class User { ...
asp.net-mvc-4 dapper sql
asked by CinnamonBun

HttpContext.Current.Cache VS. SQL Table Performance

We have a poorly designed shopping cart database. All processed objects that will be used to the front site are stored in HttpContext.Current.Cache on ...Application_Start.... Processed objects I mean results from sql script that has many joins and where ...
asp.net-mvc-4 caching dapper performance sql-server
asked by peng

Can an Dapper query to changed to an ObservableCollection?

I'm tying to learn to use dapper....I have this class here:...public class Member_Collection : ObservableCollection<Member> { } ...and I have this method in my DAL class:... public static Member_Collection SqlSelectAll(string connString) { ...
asp.net-mvc-4 dapper
asked by Harrison Brock

What are the main criteria while choosing between different ORMs

In my new project I am very confused between which ORMs to use. Our database queries are very complex. We are mainly stuck between Dapper and EF 5. I know dapper has performance benefit and i think EF has its maintenance and code generation benefit....Bel...
asp.net-mvc-4 dapper entity-framework
asked by Vishwajeet

Procedure or function expects parameter which was not supplied

My stored procedure is ...Create proc [dbo].[InsertPerson] ( @LastName VARCHAR(64), @FirstName VARCHAR(64), @Age INT ) AS INSERT INTO Person Values(@LastName,@FirstName,@Age) ...The save method of the BaseRepository class is as follo...
asp.net-mvc-4 dapper repository-pattern stored-procedures unit-of-work
asked by Mojammel Haque

Dapper Many-to-Many Query

I am trying to write a query to get a user in the system with all of his/her roles. There is a many-to-many relationship between users and roles. The joiner table is ...SystemUserUserRole... with columns ...UserId... and ...RoleId.... My models are bel...
asp.net-mvc-4 dapper
asked by Andrew

Reduce the number of database calls in a MVC website

I have a complex C# MVC 4 website that connects to multiple databases. Every request goes through the following steps...Check if user is signed in and get username from authentication cookie....Query a lookup database to figure out where the client's data...
asp.net-mvc-4 c# dapper
asked by user1625066

How to fill dropdownlist in MVC-4 using dapper

I filled Drop Down List in MVC which is working fine but now I want to do it using Dapper but got stuck....DropDownList in MVC without Dapper...Controller... [HttpPost] public ActionResult Create(User ur) { string str = @"Data Source=DEV_...
asp.net-mvc asp.net-mvc-4 dapper
asked by Navy

List getting partially filled. Id is not getting fetched using Dapper

I am trying to populate dropdown list using ...Dapper... but when I am fetching the values from ...stored procedure...ID... is not getting fetched only name is getting fetched dont know where I am going wrong. Here is my Code...Controller...public ActionR...
asp.net asp.net-mvc-4 dapper razor stored-procedures
asked by Navy

asp.net mvc 5 Dapper Json is mapping the whole model class

I am using Dapper in my ASP.NET MVC 5 application and in my query I only want 2 fields to return but the Json returns all of the fields. This is my model... public class thread { [Key] public int id { get; set; } public int?...
asp.net-mvc asp.net-mvc-4 dapper json
asked by user1591668

This Dapper Query is always returning a null

using System; using System.Collections.Generic; using System.Data.SqlClient; using System.Linq; using System.Web; using Dapper; namespace Calculate.Models { public class SelectedDetailsGetter { SqlConnection con = new SqlConnection("Data S...
asp.net-mvc-4 c# dapper mysql
asked by Gopal Chandak

Passing output parameter to an sp which accepts datatable as a parameter using dapper

Hi I am working on mvc as part of my learning, So I came accross a situation where I have to pass a datatable to the sp, along with the datatable I have to give one output parameter of ...int... also of the type. Currently I am using this code...con.Exec...
asp.net-mvc-4 dapper
asked by Binoy Kumar

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...