Dapper Tutorial - Knowledge Base (KB)
1240 results for: in tag: c#
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
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...
asked by marc_s
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...
asked by Wolfwyrd
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...
asked by Jay Stevens
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...
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...
asked by Peter
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...
asked by Doug Wilson
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) ...
asked by Stephen Patten
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) => { ...
asked by Arnej65
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 ..
asked by marcusstarnes
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.
asked by Kyle Nunery
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?
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..
asked by Giles Roberts
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...
asked by Gullu
Does Dapper work on Mono?
We're thinking about moving over to ...Mono... and I see that ...Dapper... works with MySql. However this is with a ADO.NET provider. Does Mono/Linux have a MySql ADO.NET provider and does that work with Dapper?...Eventually we are planning on moving our ...
asked by thames
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...
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...
asked by Egahn
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...
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...
asked by hark
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...
asked by newbie
Page 1 of 62