zzz projects Dapper Tutorial
Getting Started Documentation 3rd Party Libraries Knowledge Base Online Examples
  • Getting Started
  • Documentation
  • 3rd Party Libraries
  • Knowledge Base
  • Online Examples
  •   Download  

Dapper Tutorial - Knowledge Base (KB)

6 results in tag: stored-procedures

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...
c# dapper sql-server stored-procedures
asked by imodin

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...
c# dapper data-access-layer sql stored-procedures
asked by antao

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...
c# dapper datatable sql-server stored-procedures
asked by Mrinal Kamboj

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...
c# dapper sql-server stored-procedures table-valued-parameters
asked by Rahul

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 ...
.net-core c# dapper postgresql stored-procedures
asked by burak ramazan

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...
c# dapper stored-procedures
asked by Chatra

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!