Dapper Tutorial - Knowledge Base (KB)

Dapper.Tvp Assembly is does not have a strong Name

Recently I was working with Dapper.Net and it is awesome so far for dynamic object manipulations with sql, Great work by Dapper team....But there is a need to have bulk insert and update and i used table valued parameter which is better in terms of perfor...

Dapper Table Valued Parameter OleDB returns Unspecified Error

I have read your answer regarding on the use of TVP in Dapper, I also have implemented your solution but when I execute the code, Dapper returns to me an "Unspecified Error" message. I have reviewed all of the components involved: ...TVP in SQL Server...D...

Pass table-valued parameter to a stored procedure

In my project we are using Dapper to connect with database for operations....I have created a stored procedure in my SQL Server database as:...CREATE PROCEDURE dbo.usp_Check @TestTableType [dbo].[TestTableType] READONLY AS BEGIN SELECT TestTa...

Passing table as input parameter to dapper in dotnet core

While trying to pass a table in as a parameter to a stored procedure via Dapper, I came across ...this SO answer..., which indicates that it is directly supported in Dapper. ...In dotnet core however, ...DataTable seems not to be implemented..., so this d...

Use Dapper to convert a collection of objects to a TableValuedParameter

I'm trying to use TVP in dapper to insert several rows at once like this:... con.Execute(@" INSERT INTO Author ( FirstName, LastName, ParentAuthor ) SELECT FirstName, LastName, ParentAuthor FROM @TVP " ...

Understanding SqlMapper.ICustomQueryParameter

What's the point of ...DataTable.AsTableValuedParameter... method which returns a ...SqlMapper.ICustomQueryParameter... when having to pass a datatable as TVP to DB using Dapper?...I could send TVPs to DB just as normal datatable and execute queries just ...