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

When using Dapper, is there a point in making repositories Transient?

If we're using ...EntityFramework... I can see why every repository should be injected in a transient lifetime, but what if we're using ...Dapper...?...Is there any problem at all?

CRUD operation in asp.net core MVC using kendo grid and stored procedures and dapper with the Repository pattern

I am trying to do CRUD operation in asp.net core MVC, When I try to insert data into the grid(Create Function), VS turns me with an error that can not nut be null! I think the problem is UI does not send my inputs to the SQL or other things that I don't k...