Dapper Tutorial - Knowledge Base (KB)

Using Dapper, how to map a string column to a generic list?

I have the following model:...public class Model { public string Name { get; set; } public List<int> Numbers { get; set; } } ...And an ...SQL... query that returns the following dataset containing two nvarchar columns:... Name | Numbers 'foo' | '1,...

How to use an Enum as string in Dapper?

I am trying to use ...Dapper... and ...Dapper-Extensions... and to serialize my ...enums... on the database as ...string.......Right now they are serialized as integers (inside a ...VARCHAR... field) instead....Is there any way to do this? Any custom typ...

How can I log the auto generated query created by Dapper Extensions?

I am using Dapper Extensions (DE) as ORM. It is consumed in Data Access Layer which is implemented using Repository pattern. SQL Express is back-end RDBMS....DE automatically generates most of the queries for me. I want to log those auto-generated queries...

How to use Dapper and query to return a complex entity?

I have a Customer class with the following properties:...public int Id { get; set; } public string Name { get; set; } public int AddressId { get; set; } public Address Address { get; set; } ...My goal is to write a Dapper query that will use an Inner Join...