Dapper Tutorial - Knowledge Base (KB)

in .NET Core and Dapper, can you specify a lifetime/scope to a SqlConnection?

I'm using .NET Core Dependency Injection to instantiate a ...SqlConnection... object during the application startup, which I'm then planning to inject in my repository. This ...SqlConnection... will be used by Dapper to read/write data from the database w...

How to use Generic Repository Pattern 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...

When inserting, updating, or deleting a record, how to get the ID with Dapper?

When I insert or update or delete an entity with Dapper, I need to return the ...id... of entity. ...I am using this code : ...var role = await roleConnection.ExecuteAsync("UPDATE Role SET IsDelete = @isDelete, RoleName = @roleName, SecurityStamp = @secur...

How Dapper handle PostgreSQL connection using dependency injection?

I am using Dapper ORM for database operations in my asp.net core web API project. Right now I am opening the new database connection every time and using it inside ...using... block so they will get disposed when scope ends. But I was looking to handle al...