C# Dapper - How to use transactions with Dapper
Dapper is a micro ORM or a simple object mapper and it integrates smoothly with C# and its SqlConnection. The same applies to Dapper and transactions »
C# Dapper - How to call a stored procedure with a parameter
This post shows you how to call a stored procedure with a parameter using Dapper. If we have the following table with an Id (int) and »
C# Dapper - How to execute a select statement using a list of Ids with an IN clause in MSSQL
Using Dapper you can easily map results of a query to an object or a list of objects. Sometimes you want to select a list of »
C# Dapper - How to make select, insert, update and delete statements
Dapper makes it easy to "Execute a query and map the results - if any - to a strongly typed List". This post demonstrates how to »
C# Dapper - Return inserted identity
This post describes two ways to get the generated identity of a newly inserted row. We will use the following table simple table with an Id »
Dapper - have a different tablename than the name of your entity / class
Dapper [https://github.com/StackExchange/Dapper] will automatically look for a table with a name that matches your entity's name, however sometimes your entities do not »
Solution for "Invalid return type" from Dapper.Contrib when inserting row
This is another one of those embarrassing moments. I just had this issue for quite some time and I could not figure out what I was »
MSSQL/Dapper - Slow select statement on VARCHAR column with index
I recently had an odd experience with a select statement. It was a very simple select statement hitting a unique index on a varchar column. But »