Dapper Tutorial - Knowledge Base (KB)
2043 results for:
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
Dapper-dot-net "no column name"
I have a result set that might look like this:...ID (no column name) anotherID ---- ---------------- ---------- 1 super 3 1 super 4 3 duper 6 4 really 7 4 really ...
asked by John Sobolewski
Dapper is throwing an invalid cast exception when trying to set a boolean value returned from MySQL
I have this class...public class User { public int UserId { get; set; } public string UserName { get; set; } public bool IsValidated { get; set; } } ...And I'm populating it with this sql using dapper:...var users = connection.Query<User>("SEL...
asked by Glenn Slaven
Dapper with MVCMiniProfiler
I am wanting to use the MVCMiniProfiler with Dapper. Is this possible beyond wrapping the "Query" call from dapper in "Using Profiler.Step" block?...I have this basic Dapper call:...Dim comments As List(Of Comment) Using conn = New SqlConnection(Connectio...
asked by ericdc
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
Dynamic where clause in dapper
Is it possible to add and remove criteria on the fly with dapper? I need this to implement user driven filtering. It is not feasible to have a query for each filter as there are too many combinations.
asked by NabilS
Dapper micro ORM, database agnostic and MySql Guid type
I am experimenting ...Dapper... on a pet project. I am using ...SQLite... to run all the tests and MySql for "production". However I am not sure how to best use Dapper to handle database agnostic situation....The particular problem I am having is with MyS...
asked by Jeff
Dapper.NET multi mapping TSecond Deserializer is null
I'm trying to perform a very standard multi mapping query using Dapper, and I'm getting the following error. I also get another error occasionally when this seems to work, but I'm unable to reproduce it at the moment. I'll append it to this post if/when t...
asked by George
Parameterized LIKE clause in SQL statement using Dapper
I want to perform the following query using Dapper, which currently doesn't return expected results (I think it must be treating the @pName param as literal text within the single quotes?):...var q = "SELECT * FROM Users WHERE Name LIKE '@pName%'"; ...@pN...
asked by marcusstarnes
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
How do I map lists of nested objects with Dapper
I'm currently using Entity Framework for my db access but want to have a look at Dapper. I have classes like this:...public class Course{ public string Title{get;set;} public IList<Location> Locations {get;set;} ... } public class Location{ p...
asked by b3n
Correct use of Multimapping in Dapper
I'm trying to use the Multimapping feature of dapper to return a list of ProductItems and associated Customers. ...[Table("Product")] public class ProductItem { public decimal ProductID { get; set; } public string ProductName { get; set; ...
asked by Richard Forrest
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
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
How can I use Dapper's strongly-typed query parameters with Sybase ASE?
Dapper... can pass query parameters as anonymous objects, and supports any ADO.NET data provider. However, when running the following query against the Sybase 15 ADO.NET drivers:...using (var connection = new AseConnection("...")) { connection.Open();...
asked by Richard Dingwall
How to get a bigint to a long object property from SQL Server using Dapper?
I have a ...bigint... in my table and when I try to do a select using Dapper, it is not working. I found a tip that said to cast to numeric, but that is throwing a invalid cast error....What is the correct cast to use with dapper?
asked by jpshook
how to convert Dictionary<dynamic, dynamic> to Dictionary<string, string> using Colllection.ToDictionary()
I am using Dapper to fetch a 2 column resultset into a dictionary. I noticed that intellisense shows me a .ToDictionary() when I hover over the resultset but I cannot get it to work since dapper uses dynamic properties/expandoObject...Dictionary<string, s...
asked by Gullu
Dapper - using multimapping with split points other than Id
I know this is similar to ...Correct use of Multimapping in Dapper..., but I think it's slightly different. ...I have the following POCO structure:...public class Customer { public int customerkey { get; set; } public string FirstName { get; set; ...
asked by dankorz
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 4 of 103