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)

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...
asp.net-mvc-3 c# dapper n-tier-architecture
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.
asp.net-mvc-3 dapper orm
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("...
asp.net-mvc-3 dapper mvc-mini-profiler
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?
asp.net-mvc-3 dapper entity-framework-4 mvc-mini-profiler
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...
asp.net-mvc-3 c# dapper mvc-mini-profiler mysql
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; } ...
asp.net-mvc asp.net-mvc-3 dapper
asked by Matías Romero

Connection Pooling with Dapper.net

Where can I find more information on connection pooling with Dapper.net?
asp.net-mvc-3 c# dapper
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?
asp.net-mvc-3 c# dapper mysql oracle
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 =...
asp.net-mvc-3 c# dapper
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...
ado.net asp.net-mvc-3 dapper entity-framework
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...
asp.net-mvc-3 dapper n-tier-architecture
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...
asp.net-mvc-3 dapper nhibernate
asked by Sunny

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...
asp.net-mvc-3 dapper
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...
architecture asp.net-mvc-3 dapper
asked by ashes999

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...
asp.net-mvc-3 dapper sql-server-2008
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...
asp.net-mvc-3 c# dapper
asked by Roger

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..
asp.net-mvc-3 c#-4.0 dapper sql-server-2008
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 ...
asp.net-mvc-3 asp.net-mvc-4 dapper mysql
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...
asp.net-mvc-3 dapper parameters
asked by user1949387

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...
asp.net-mvc-3 c# dapper stored-procedures
asked by Sham

Page 1 of 2
  • 1
  • 2
  • ยป

Prime Library

Performance

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

Expression Evaluator

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