Dapper Tutorial - Knowledge Base (KB)
17 results 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.
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 , ...
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....
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 ...
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
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 { ...
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 ...
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) { ...
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...
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...
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...
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...
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_...
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...
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?...
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...
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...
asked by Binoy Kumar
Page 1 of 1