Dapper Tutorial - Knowledge Base (KB)
1868 results for:
Using Dapper with BLOBs and SQL Server CE
When using BLOBs with more than 8000 bytes of data, you need to specifically set ...Parameter.SqlDbType = SqlDbType.Image... to make it work (...as explained here...)....Dapper, when it sees a ...byte[]... field, defaults to a ...SqlDbType.Binary..., whic...
asked by Sameera
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
How to implement generic IEnumerable or IDictionary to avoid CA1006?
Out of curiosity i would like to know how to best implement a class that could be used to avoid the CA1006 warning...CA1006 : Microsoft.Design : Consider a design where 'IReader.Query(String, String)' doesn't nest generic type 'IList(Of IDictionary(Of Str...
asked by mrt181
is there an ExecuteScalar in Dapper
it looks like there was an ExecuteScalar in Dapper......http://code.google.com/p/dapper-dot-net/issues/attachmentText?id=22&aid=220000000&name=ExecuteScalar.cs&token=9e2fd8899022f507b140ffb883c60e34...Was ExecuteScalar renamed or removed?...Can this now b...
asked by sgtz
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
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 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
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
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
Can I use DynamicParameters with Template and have a return parameter in dapper?
The system I am currently working on uses Stored Procedures for all data access. I'm looking into Dapper at the moment (so far it looks great) but I was wondering if I can use a DynamicParameters object created using a Template but make one of the parame...
asked by Fermin
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
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 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
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
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
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
Mono + SQLite + Dapper SQLite Exception during Insert
I am using Mono, SQLite, Dapper & Dapper Extensions. I can read from the database but Insert is not working. I am using Mono Driver for sqlite. ...Error is not very informative, atleast to me. Any help will be much appreciated....Error: ...SQLite error ne...
asked by Chirdeep Tomar
Page 2 of 94