Dapper Tutorial - Knowledge Base (KB)

Dapper.net - how to map many to many relationship in single command

I have a Place object....It can have many Tags associated with it....Tags can be associated with many Places....(Although this is a many to many relationship - I guess conceptually it may as well be a one to many - a collection of objects - with each obje...

Call a function on each record from dapper result

I am trying to call a function on each record that will set some field values. When the results are meant to be paged then this is achieved in the following way:...public IDataWrapper GetPagedQuery<T>(string myQuery, object param, Action<T> customAction)...

Better way to cache a Model

My simple repository's getAll method:... public List<ListModel> GetAllLists() { using (MySqlConnection connection = new MySqlConnection(this.connectionString)) { return connection.Query<ListModel>("SELECT * F...

Get LAST_INSERT_ID from transaction

I have the following code:... using (MySqlConnection connection = new MySqlConnection(this.connectionString)) { connection.Open(); using (MySqlTransaction transaction = connection.Begi...

Insert Guid and retrieve value with dapper

I am trying to insert a record into my database and retrieve the GUID it just added in....Let's say if I have a table with 3 columns, ...GUID..., ...FirstName..., ...LastName.... I need to insert a new record and then get back the GUID that was just gener...

Dapper ORM vs Stored Procedure

I am working on a project where we are using DbContext but not EF for CRUD functionalities. We are using service layer for our business logic where stored procedures are written to fetch/send data to the database. I got to know about Dapper ORM which allo...

Dapper Syntax - 2016

I'm just beginning my first MVC project using Dapper (and Dapper.Contrib) instead of EF. I'm trying to make sure I'm using the proper syntax when using it. Searching the web, I can see that as Dapper has evolved, so has some of its requirements and synt...

MVC Repository, Unity, Identity Error

I'm starting a new project using MVC 5, Identity 2.x, Unity, and Dapper. I'm using the standard EF functionality for Identity but using Dapper for the rest of the DB access. I'm using a Repository Pattern for all my (non-Identity) DB calls. ...I'm fair...

Dapper query object with a child of IEnumerable

I am trying query all countries and in each country object it would fill up the provinces....I have the following Classes...public class Country { public int Countryid { get; set; } public string CountryName { get; set; } public IEnumerable<P...