Dapper Tutorial - Knowledge Base (KB)
27 results for: in tag: asp.net-mvc-3
Where to put sql when using dapper?
I'm using dapper for a mvc3 project at work, and I like it. However, how are you supposed to layer the application when using dapper? Currently I just have all my sql stuffed directly in the controller (...slap...) but I was thinking of making a class wit...
asked by Christian Wattengård
Any good samples for getting started with Dapper?
I'm trying to get started with Dapper in an exisiting MVC3 project and although it looks very easy to use, I can't seem to find any tutorials on how to set it up intially. Any links or suggestions would be highly appreciated....Thanks a lot.
asked by Robert C.
How to pass a mvc-mini-profiler connection to a base class from MVC3
Given this snippet of code...public abstract class Foo { private static SqlConnection _sqlConnection; protected SqlConnection GetOpenConnection() { if (_sqlConnection == null) { _sqlConnection = new SqlConnection("...
asked by Stephen Patten
Can I have more than one profiled connection with MVC Mini Profiler?
I'd like to use a mixture of both Dapper and EF 4 in my MVC3 application. Is it possible to have more than one profiled connection, or share a profiled connection?
asked by Stephen Patten
Dapper conversion of TinyInt
I'm attempting to write my own DatabaseStorageBase for mini-profiler, and I'm running into issues in my...private List<T> LoadFor<T>(DbConnection conn, object idParameter) ...method. Dapper keeps yelling at me with...Error parsing column 5 (level=0 - SBy...
asked by JesseBuesking
Matching multiple classes with dapper
How can I retrieve this objects with Dapper? For example:...public class ClassA { public int Id { get; set; } public string Text { get; set; } public ClassB b { get; set; } public ClassC c { get; set; } public ClassD d { get; set; } ...
asked by MatÃas Romero
Dapper Not Populating Fields and Throwing Exceptions
I'm switching from ActiveRecord to Dapper. I have a simple Project class with a couple of fields:...Id (int)...Name (string)...Secret (guid)...OwnerId (guid)...My initial attempt to use Dapper resulted in this code: I'm using Dapper like so:...List<Projec...
asked by ashes999
Where to put my queries - model vs. controller
I ...just switched from ActiveRecord/NHibernate to Dapper.... Previously, I had all of my queries in my controllers. However, some properties which were convenient to implement on my models (such as summaries/sums/totals/averages), I could calculate by i...
asked by ashes999
Connection Pooling with Dapper.net
Where can I find more information on connection pooling with Dapper.net?
asked by Bill
Using Dapper.net with MySql & Oracle
All the samples online show that Dapper.net works with SQL Server. What about other Databases like mySQl or Oracle? Is there a guideline or sample on how to do so?
asked by Bill
How to bind Dapper.NET with MS Charts?
I need to bind Dapper.NET dynamic query with MS Charts....So the question is , how do i get it done?...public class HomeController : Controller { private readonly ChartModel _model; public HomeController(ChartModel model) { _model =...
asked by IamStalker
EF to ADO.NET transition
Need suggestion for migration few modules of asp.net mvc 3 application: Right now we are using EF with POCO classes, but in the future for some performance driven modules we need to move to ADO.NET or some other ORM tool (may be DAPPER.NET)....The issue w...
asked by Burhan Farooq
ASP.NET MVC layer separation with SQL Dapper and NHibernate
I am working on an ASP.NET MVC application using SQL Dapper for retrieval and NHibernate for CRUD. I am facing some problems with layer separation. ...I have repositories say UserRepository which has ...public User GetUsersList()... method. Here "User" is...
asked by Sunny
Will Dapper for retrieval and NHibernate for CRUD work for a web application
I am planning to use "Dapper" for retrieval and "NHibernate" for CRUD operations. So, would it be a good design to follow this approach. One of the problems I recently faced is with CRUD Screens....Suppose I have Edit Order form. I am retrieving the entit...
asked by Sunny
Dapper returns null for SingleOrDefault(DATEDIFF(...))
I have a SQL statement similar to:...SELECT DATEDIFF(Day, startDate, endDate) FROM Data WHERE ProjectId=@id...In the case where ...Data... doesn't have any records for ...ProjectId..., SQL Server returns null....In Dapper, I execute this via:...value = co...
asked by ashes999
A parameterless default constructor is required to allow for dapper materialization error when reading object with list of child objects
I have this:...public class object_a { public int ta_Id { get; set; } public string ta_Label { get; set; } public IEnumerable<table_c> SomeName { get; set; } } public class table_b { public int Id {get;set;} public int SomeId {get;set...
asked by Roger
Dapper with multimapping using stored procedure
This is regarding Dapper in ASP.NET MVC3....I have two tables ...tblBranchMaster..., ...tblZoneMaster... in my database and two class file with same details....tblBranchMaster(ID, ZoneID, Name); tblZoneMaster(ID, Name); ...Both table having primary ke...
asked by Sham
Cache solution for Dapper when using stored procedures (MSSQL)
I'm using ...Dapper... mainly for calling ...stored procedures... in the database ...MSSQL 2008 R2....I do not have classes that map to database tables. Most of the data ends up in ...IEnumerable <Dynamic>... and is transmitted to the grid on the screen..
asked by Tomasito
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
mvc3 dapper parameter issue
I have dapper working correctly, but it is unsecure as in I haven't been using parameters, how can I best turn my dapper variables into parameters for instance this is the unparameterized code that I had that worked.....var getinfo = sqlConnection.Query<t...
asked by user1949387
Page 1 of 2