Dapper Tutorial - Knowledge Base (KB)

Repository Pattern Where and Lightweight ORMs

For my IRepository, i would like:...To have it be usable by a micro-orm like dapper, petapoco, massive etc... for the SPEED...To have where clauses that get run on the server, hopefully using Expression/IQueryable style (which is also very swappable)...Is...

Procedure or function expects parameter which was not supplied

My stored procedure is ...Create proc [dbo].[InsertPerson] ( @LastName VARCHAR(64), @FirstName VARCHAR(64), @Age INT ) AS INSERT INTO Person Values(@LastName,@FirstName,@Age) ...The save method of the BaseRepository class is as follo...

How to implement Unit Of Work pattern with Dapper?

Currently, I am trying to use Dapper ORM with Unit Of Work + Repository Pattern....I want to use Unit of Work as opposed to a simple dapper Repository due to the fact that my insert and updates require a degree of transaction processing. I have been unabl...

Connection design issue in Dapper, UoW, Generic Repository and multiple databases

I'm trying to build a repository layer for an application which interacts with 3 databases, all MSSQL. I made the repository structure is based on ...Dapper and Unit Of Work Pattern... and looks like below: ...Is this a good design? or what could be a bet...

How can I return data in this specific way

I am building an angularjs app with a c# backend with dapper micro orm which gets me data from the database. ...I wanted the data returned to look like this: ...[{ "CategoryId": 1, "CategoryName": "cat1", "Items": [{ "I...

Support both MS-SQL and Oracle

I have developed an enterprise product which is currently live in a few sites. This was developed on the MS stack using SQL server as back-end data storage. I have not used EF/NHibernate for data-access, instead used dapper and some custom extensions arou...

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 ...

Difference between a 'using statement' for every SqlConnection and single SqlConnection as private property in C# data layer

When implementing the repository pattern using Dapper ORM I am currently doing the following:...private readonly ConnectionStrings _connectionStrings; private IDbConnection _db; public CustomerRepository(IOptions<ConnectionStrings> connectionStrings) { ...

Dapper with UOW - Don't close connections

I have implemented my DAL with Dapper by using following artical...Dapper Implementation...But It is created a connection with db each and every database call. It does not reuse connection pool. I believe i have closed and disposed the connection properly...

Designing Model with foreign key

I am building an ORM by using Unit or Work and Repository using Dapper. I have searched the internet on this problem and no luck....I have the following tables:...As you can see, Instance has Entity inside. I have 2 approaches:...Approach 1:...public clas...

Generic Repository pattern for .net core with Dapper

I followed a tutorial on Generic Repository Pattern with ASP.NET core with EF CORE, ...here... for example ... public class Repository<T> : IRepository<T> where T : class { protected readonly DbContext _dbContext; protected readonly DbSet<T...

C# Repository Pattern for each DB entities or by module

I have a ...c#...WebApi... project that uses ...Dapper... with ...Repository Pattern... for data layer....In other projects I have created a Repository by module of by business logic. So instead of having a Repository for each entity I create one Reposito...