Dapper Tutorial - Knowledge Base (KB)

dapper PropInfo Setter for inherited EntitySet from abstract class reference is null

I am trying to replace a nasty LINQ 2 SQL hit with some dapper queries to improve performanace. In doing so I have to weave a bunch of different objects together in order to create the big object required to hold all the information I need for ASN informa...

Call custom constructor with Dapper?

I'm trying to use Dapper to interface with the ASP.NET SQL Membership Provider tables. I wrapped the SqlMembershipProvider class and added an additional method to get me the MembershipUsers given a certain criteria relating to some custom tables I have..

Get class from Type with Reflection and call a generic constructor with Type in C#

I am working with Dapper and I want to iterate through my model classes and set type mapping for any class having a field decorated with a ...ColumnAttribute.... ...public class ColumnAttributeTypeMapper<T> : FallbackTypeMapper { public static readonl...

Creating type dynamically at runtime for dapper querymultiple Read method using Reflection

I'm trying to pass type of class dynamically at runtime. The below code give error at code section:... object newObject Activator.CreateInstance(Type.GetType(t.GetGenericArguments()[0].FullName)); data.Read<newObject>(); ...I've also tried... da...

Getting the content of DynamicParameters in Dapper

We are migrating databases from Oracle to MySQL. Oracle and MySQL use a different character for the bind variables ...@... and ...:.... We are using Dapper to query the database. We pass in DynamicParameters into Dapper and the bind variables work....What...

Is there a way to pass a TVP to dapper on .Net Core right now?

I am using .net core and dapper, the first one doesn't have DataTables and the second one use them for TVP....I was trying to convert a ...List<T>... to a ...List<SqlDataRecord>..., create a SqlParameter with this list and then convert it to a DynamicPara...

Dynamic Func<> for Dapper query map

I'm attempting to dynamically generate and execute the sql for ...Dapper... with the aim to simply pass in a type and the sql is generated and executed dynamically....Example classes:...public class User { [Key] public int UserId { get; set; } ...

Dapper vs ADO.Net with reflection which is faster?

I have studied about Dapper and ADO.NET and performed select tests on both and found that sometimes ADO.NET is faster than Dapper and sometimes is reversed. I understand this could be database issues as i am using SQL Server. As it is stated that reflecti...

Change TableAttribute in runtime for Dapper

I use ...Dapper... and ...TableAttribute...:...using Dapper.Contrib.Extensions; namespace MyCompany.Entities { [Table(Config.TABLE_ARCHIVO_CLIENTE)] public partial class ArchivoCliente { ...Working... public const string TABLE_ARCHIVO_CLIEN...

How to trim all strings from a complex object returned with dapper

I am working with a legacy database, within this database, the data get assigned the maximum length of the column. if the string data is shorter, it will automaticly fill in whitespaces at the end....What i'm trying to do is trim all these ending whitespa...

How to return List<dynamic> with Dapper.NET ORM that can bindable?

This question is old now, Dapper data-view binding are fixed... as shown answer below :)