Dapper Tutorial - Knowledge Base (KB)

How to execute in Dapper a stored procedure with user-defined table type (UDT) parameter?

I have a stored procedure ...InsertCars... which accepts list of user defined table type ...CarType.......CREATE TYPE dbo.CarType AS TABLE ( CARID int null, CARNAME varchar(800) not null, ); CREATE PROCEDURE dbo.InsertCars @Cars AS CarType RE...

In Dapper, how to execute a stored procedure without parameter?

I'm using ...Dapper... (thanks ...Sam..., great project.) a micro ORM with a DAL and by some reason I'm not able to execute stored procedures with input parameters. ...In a example service I've the following code: ...public void GetSomething(int something...

How to pass Table Valued Parameters with Dapper Dynamic Parameters?

I was trying to create a generic method, which can read the parameters name and value from a class at Runtime and create parameter collection for Dapper query execution. Realized that till the point all parameters are Input type it works well, but if I ha...

Using Dapper, how to map a stored procedure to a table-valued parameter?

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

How to use Dapper to execute a Postgre function?

I get an error when I try to call a postgre function using dapper. Where did i do wrong? I'll be glad if you can help me....Error Message: ... availability_list(facilityId => integer, startDate => timestamp without time zone, endDate => timestamp without ...

How to pass a list of integer to a Stored Procedure with Dapper?

My stored procedure SQL statemet is very simple....Delete From TableName where ID IN (@id) ...I want to pass list or array from C# code and wants to RETURN Number of rows deleted....Below is my code, somehow I am not convinced and think this is not the ri...