Dapper Tutorial - Knowledge Base (KB)
19 results in tag: .net
How to set the CommandTimeout value in Dapper?
I'm trying to run SQL backups through a stored procedure through Dapper (the rest of my app uses Dapper so I'd prefer to keep this portion running through it as well). It works just fine until the CommandTimeout kicks in....using (var c = SqlConnection(co...
asked by sh-beta
How can I use Dapper and manage the database connections?
I've been playing with Dapper, but I'm not sure of the best way to handle the database connection. ...Most examples show the connection object being created in the example class, or even in each method. But it feels wrong to me to reference a connection...
asked by Donald Hughes
Do Dapper is safe from SQL Injections?
How does Dapper help protect against SQL injections? I am testing out different DAL technologies and have to choose one to be secure our site. I'm leaning towards Dapper (http://code.google.com/p/dapper-dot-net/), but need some help learning about securit...
asked by cdub
How to use CancellationToken with Dapper async methods?
I'm using Dapper 1.31 from Nuget. I have this very simple code snippet,...string connString = ""; string query = ""; int val = 0; CancellationTokenSource tokenSource = new CancellationTokenSource(); using (IDbConnection conn = new SqlConnection(connString...
asked by Pedigree
How to use Dapper to return a list of dynamic types (list<dynamic>)?
I have been using Dapper.net for a while now and its a very good ORM mapper which works great with .Net dynamic types....But I noticed that when Dapper retrieves data from a database it returns as ...DapperRow... type....Is there are any way that I can re...
asked by Husni Jabir
What best practices to use for connection and query in Dapper?
So i've read a bunch of links/SO questions, but i still can't get a clear answer on this....When performing SQL queries with Dapper in an ASP.NET application, what is the best practice for opening/closing connections?...Here's the pattern i'm currently fo...
asked by RPM1984
Why using Dapper I get an issue with Oracle stored procedure with refcusors as out parameter?
Given this oracle stored proc package:...CREATE OR REPLACE PACKAGE TESTPKG AS FUNCTION TestReturnRefCursor RETURN SYS_REFCURSOR; PROCEDURE TestingRefCursorsAsOutParam (outp OUT SYS_REFCURSOR); END TESTPKG ...And this package body:...CREATE OR REPLAC...
asked by J.T. Dorion
How to use an Enum as string in Dapper?
I am trying to use ...Dapper... and ...Dapper-Extensions... and to serialize my ...enums... on the database as ...string.......Right now they are serialized as integers (inside a ...VARCHAR... field) instead....Is there any way to do this? Any custom typ...
asked by MaurGi
How to use QueryMultiple method to allows you to get a result and a count at the same time in Dapper?
I wrote two segments of SQL command and want to process in one query like this:...SELECT COUNT(*) FROM books SELECT * FROM books ORDER BY bookID OFFSET 1000 ROWS FETCH NEXT 10 ROWS ONLY ...How can I use ...conn.QueryMultiple... method to get ...count... ...
asked by ineztia
When passing in a model, how can I create a dynamic where clause using Dapper?
I have an example model that looks like this:...public class PersonModel { public int Id {get; set;} public string FirstName {get; set;} public string Lastname {get; set;} public string City {get; set;} } ...In my repository I want to ...
asked by Eldorian
How to use Dapper with Repository Pattern / Unit of Work?
Coming up with a good solution using ...Dapper, Repositories, and Unit of Work... has been a challenge for me. I've done a lot of research and have seen implementations where the ...Unit of Work... class has a ...dictionary of repositories.... That doesn'...
asked by Singularity222
How to return a list of data to Dapper by executing a stored procedure?
I am trying to return data using Dapper via stored proc...My DTO Class is similar to below (removed some properties for brevity)...public class CarDTO { public int CarID { get; set; } public string Manufacturer { get; set; } public List<CarOpt...
asked by Ctrl_Alt_Defeat
How to read column names from a dynamic variable index with Dapper?
I have an sproc which returns variable number of columns with different column names based on input parameter given to it. (and also number of rows >= 1)...For example, if input is 3, sproc returns 3 columns, and if input is 5, it returns 5. (Not sure on ...
asked by G_S
With Dapper, how can you may map a list of nested entity?
I'm using Dapper and I have classes like this:...public class Region { public Region() { Countries = new List<Country>(0); } public int RegionID { get; set; } public int RiskRank { get; set; } public string Name { get; se...
asked by Ameya Rane
When I execute my sp GetAllUsers in Dapper, why do I get a sequence contains no matching element error?
Hello my question is I have 2 table one is User table the other one is CustomerUsers I select them by Deleted=0 When I try to list all users and have customerId, I am having issue that sequence contains no matching element error... My Code is below any he...
asked by phantasmagoria1985
Using a stored procedure, how with Dapper can I insert many rows into two tables?
I am using Dapper (...https://github.com/StackExchange/Dapper...) in asp.net core myweb api project. I have a requirement to create a master record and insert a set of rows into a child table....Ex. OrdersMaster table create an order id in this table ...
asked by blue
How with Dapper to insert in a temproary table?
I am trying to insert a List of integers into a temporary table using Dapper. I wrote my query based on the selected answer to this Stack Overflow ...question.... However, I get a syntax error when running the query....Code:...List<int> lst = new List<int...
asked by Drob337
What is the best way to convert DapperRow to Dictionary<string,string> in Dapper?
I've a method that returns IEnumerable with Dapper Row. ...But I'm trying to access the data without typecasting it to a particular class and I'm getting null value.
asked by ThejaSingireddy
Why I get an error in Dapper with column string parsing?
I have the following table...create table tblWorkers ( Id int identity, WorkerId nvarchar(8), Username NVARCHAR(50) not null, Password NVARCHAR(12) not null, Token NVARCHAR(max) null, CONSTRAINT PK_WorkerId PRIMARY KEY (WorkerId) ...
asked by Techie