Dapper Tutorial - Knowledge Base (KB)

Unit of Work pattern - managing parent child relationships

I'm using a micro-orm (dapper) and am trying to come up with a Unit Of Work (UoW) implementation for my repositories to use. I am a little bit stumped how best to deal with parent-child (foreign key) relationships in my UoW. So for example if I have the f...

C# database access, Dapper, SQL and POCOs - programming design

Let's say we have a table in SQL represented in C# like this:...public class Product { public int ID { get; set; } public string Name { get; set; } public string Picture { get; set; } // filename of the picture, e.g. apple.jpg public int Categ...

Repository vs Service pattern in DAL: EF and Dapper

I'm working on project and I need to design the DAL. I will be using ...Entity Framework... for most of the project and ...Dapper... for some performance-sensitive areas. ...I was thinking about using the Repository pattern but then EF already implements ...

Best practices to manage entities while querying the data out of tables?

Each table in my database has it's own ...POCO... class. Now, I have started to write complex SQL joins and the query resultset should be mapped to some Entity which can be sent to the Business Manager (another layer) for further processing. For an exampl...

Repository Design Pattern with Dapper

This is maybe more a question for code review rather than stack overflow....I am using Dapper for a MicroORM to retrieve and Save Data to SQL Server 2014. I have got DTO classes in a DTO Proj that represent the Data retrieved from the DB or saved to the ...

Custom C# Dapper ORM wrapper

I am developing asp.net web API REST services. My data is stored in MySQL relational database. In data access layer I would like to use Dapper micro ORM, so I would like to create some kind of my own ORM wrapper methods. If I decide in the future to chang...

How to load entity from multiple tables with Dapper?

In my app i use Entites as Tables in database representation....I have an OrderEntity, that have fields like ProductEntity, CustomerEntity, then CustomerEntity has fields like AddressEntity etc....Now I try to get OrderEntity filled with all the entity-ty...