Dapper knowledge Base | Dapper Tutorial and Documentation

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

Can't get multi-mapping to work in Dapper

Playing around with Dapper, I'm quite pleased with the results so far - intriguing!...But now, my next scenario would be to read data from two tables - a ...Student... and an ...Address... table....Student... table has a primary key of ...StudentID (INT I...

c# dapper multi-mapping

asked by marc_s

How do I select an aggregate object efficiently using Dapper?

Lets say that I have a series of objects that form an aggregate....public class C{ public string Details {get;set;} } public class B{ public string Details {get;set;} public List<C> Items {get;set;} } public class A{ public long ID {get;set;} p...

c# dapper sql

asked by Peter

Dapper and anonymous Types

Is it possible to use anonymous types with Dapper?...I can see how you can use dynamic i.e. ...connection.Query<dynamic>(blah, blah, blah) ...is it then possible to do a ....Select(p=> new { A, B ,C }) ...or some variation of that afterwards?...Edit...I...

c# dapper orm

asked by Peter

Is there a way to access the columns in a Dapper FastExpando via string or index?

I am pulling in a ...Dapper FastExpando... object and want to be able to reference the column names dynamically at run time rather than at design/compile time. So I want to be able to do the following:...var testdata = conn.Query("select * from Ride Wher...

c# dapper dynamic

asked by Jay Stevens

Using Dapper with Oracle

We use Oracle as our database provider and have looked into replacing some of our data access layer (hard to maintain, harder to merge XSD's) with a saner repository based pattern using Dapper at the bottom layer. However, we have hit a number of issues w...

c# dapper oracle

asked by Wolfwyrd

Clarification of Dapper Example Code

I'm trying to grok Dapper and seem to be missing something very fundamental, can someone explain the following code taken from the Dapper home page on Google code and explain why there is no From clause, and the second param to the Query method (dynamic) ...

c# dapper

asked by Stephen Patten

Read/Write distribution over MySQL Master/Slaves using Dapper

Would dapper have any problems with using two IDbConnection objects for distributing Writes and Reads between MySQL Master/Slaves?

asp.net c# dapper mysql

asked by Kynth

Dapper parameterised queries with LINQ autogenerated types

I'm using a combination of LINQ and Dapper in my work. I'm replacing my LINQ code with Dapper in places for performance reasons. I have a lot of LINQ data objects created by dragging and dropping into the Visual Studio database diagram from SQL Server..

c# dapper linq

asked by Giles Roberts

Unexpected behaviour with a multi-mapping query using Dapper.net

I've only just started looking at Dapper.net and have just been experimenting with some different queries, one of which is producing weird results that i wouldn't expect....I have 2 tables - ...Photos... & ...PhotoCategories..., of which are related on ..

asp.net c# dapper mapping

asked by marcusstarnes

How to periodically flush dapper.net cache when used with SQL Server

Can someone please explain what this means (from the Dapper.net website)...Limitations and caveats...Dapper caches information about every query it runs, this allow it to materialize objects quickly and process parameters quickly. The current implementati...

c# dapper orm sql-server-2005 tsql

asked by Gullu

dapper -multi-mapping: flat sql return to nested objects

I have a company that contains an address object. The SQL return is flat, and I'm tring to get Query<> to load all the objects....cnn.Query<Company,Mailing,Physical,Company>("Sproc", (org,mail,phy) => { ...

c# dapper

asked by Arnej65

Can Dapper batch a set of stored proc calls?

Can ...Dapper... batch a set of stored proc calls? I see it supports Multiple Results in the documentation but I'm not sure if you can execute multiple stored proc calls using Dapper.

.net c# dapper

asked by Kyle Nunery

Why doesn't Select() convert a IEnumerable<dynamic> to IEnumerable<StrongType>?

I'm trying to use Dapper simply to map my database tables to types in C#, however, some of my types need additional elements that are not in the table. To do this I am using a factory that can take column values and set the appropriate properties....publ...

c# dapper linq

asked by Doug Wilson

Dapper performance results seem very similar on my machine

I ran the performance tests that came with the dapper source code: ...http://code.google.com/p/dapper-dot-net/...For the most part, the performance between the various data access methods were very very similiar, my results were in the 1200ms to 1500ms ra...

c# dapper performance

asked by codecompleting

Using Dapper with Oracle stored procedures which return cursors

How would one go about using ...Dapper... with Oracle stored procedures which return cursors?...var p = new DynamicParameters(); p.Add("foo", "bar"); p.Add("baz_cursor", dbType: DbType.? , direction: ParameterDirection.Output); ...Here, the DbType is Syst...

.net c# dapper oracle

asked by hark

Duplicate field name problem in a nested multi-mapping Dapper pagination query

I've ran into an issue when trying to do multi-mapping using Dapper, for pagination queries....Because I am using a nested query in this pagination scenario, there are multiple tables within the nested query that I must join to get my multi-mapped data, b...

.net c# dapper orm

asked by marcusstarnes

Is it possible to declare an anonymous type in C# with a variable/dynamic set of fields?

In C#, I would like to figure out if it's possible to declare an anonymous type where the fields are not known until run-time....For example, if I have a List of key/value pairs, can I declare an anonymous type based on the contents of that list? The spe...

anonymous-types c# dapper dynamic

asked by Egahn

C# Database Mapper

I was looking to map my database query results to strongly type objects in my c# code. So i wrote a quick and dirty helper method on the SqlConnection class which runs the query on the database and uses reflection to map the record columns to the object p...