Dapper Tutorial - Knowledge Base (KB)
294 results in tag: sql-server
Session-Per-Request with SqlConnection / System.Transactions
I've just started using Dapper for a project, having mostly used ORMs like NHibernate and EF for the past few years....Typically in our web applications we implement session per request, beginning a transaction at the start of the request and committing i...
asked by Ben Foster
Dapper.NET and stored proc with multiple result sets
Is there any way to use Dapper.NET with stored procs that return multiple result sets?...In my case, the first result set is a single row with a single column; if it's ...0... then the call was successful, and the second result set will contain that actua...
asked by marc_s
Increase performance on query with a lot of one-to-many mappings
I'm using Entity Framework to SQL Azure and in one page of my application we show quite a bit of related data to the user. We're loading a max of 30 items on the page but each item has 5 one-to-many mappings to other objects. The query time is at a reason...
asked by BZink
How to get a bigint to a long object property from SQL Server using Dapper?
I have a ...bigint... in my table and when I try to do a select using Dapper, it is not working. I found a tip that said to cast to numeric, but that is throwing a invalid cast error....What is the correct cast to use with dapper?
asked by jpshook
How do I perform an insert and return inserted identity with Dapper?
How do I perform an insert to database and return inserted identity with Dapper?...I've tried something like this:...string sql = "DECLARE @ID int; " + "INSERT INTO [MyTable] ([Stuff]) VALUES (@Stuff); " + "SELECT @ID = SCOPE_IDE...
asked by ppiotrowicz
How do I call a stored procedure with unconventional parameters?
I'm attempting to integrate Red Gate's SQLBackup Pro software into my in-house backup software, written in C#. The natural way to do this is via their ...Extended Stored Procedure.... The problems is that it's called in a format I've never seen before:...
asked by sh-beta
Correct method of deleting over 2100 rows (by ID) with Dapper
I am trying to use ...Dapper... support my data access for my server app....My server app has another application that drops records into my database at a rate of 400 per minute....My app pulls them out in batches, processes them, and then deletes them fr...
asked by Vaccano
Dapper simple mapping
Table:...create table Documents (Id int, SomeText varchar(100), CustomerId int, CustomerName varchar(100) ) insert into Documents (Id, SomeText, CustomerId, CustomerName) select 1, '1', 1, 'Name1' union all select 2, '2...
asked by sventevit
Dapper intermediate mapping
Slightly more advanced mapping then in my ...previous question... :)...Tables:...create table [Primary] ( Id int not null, CustomerId int not null, CustomerName varchar(60) not null, Date datetime default getdate(), constraint PK_Prima...
asked by sventevit
DynamicObject returned by dapper query doesn't contain all selected columns
I'm using dapper.net to execute an insert as follows:...var columns = conn.Query("INSERT INTO MyTable" + "(Col1, Col2, Col3)" + "VALUES (@Col1, @Col2, @Col3)" + "SELECT Id, ComputedColumn FROM MyTab...
asked by w.brian
sp_executesql is slow with parameters
I'm using dapper-dot-net as an ORM and it produces the following, slow-executing (1700ms), SQL code. ...exec sp_executesql N'SELECT TOP 5 SensorValue FROM "Values" WHERE DeviceId IN (@id1,@id2) AND SensorId = @sensor AND SensorValue != -32768 AND SensorVa...
asked by m__
Minimizing table locking on a SqlDataReader loop?
I have the following scenario (exception handling removed, code simplified):...SqlDataReader rdr = executeQuery(query); while (rdr.Read()) { //There are thousands of records, so this happens thousands of times handleRecord(rdr); //Takes a couple of ...
asked by Vinko Vrsalovic
Dapper Multiple Results From single query
Hi i am trying to get to grips with Dapper. ...My situation is i want to pull two values from a query into two separate strings. Im not sure if i am going about this in the correct way, but this is what i am doing:...string sql = @"Select type, name ...
asked by gdp
sqlite and sqlserver with dapper
I'm using dapper with SQL Server, but using Sqlite for some in memory tests for my unit tests....I have a class as follows...public class Test { public int ID {get;set;} public string Name } ...If I query using dapper with a SQL Server connection, it...
asked by Chris
Mapping SqlGeography with Dapper
I have entity "Point", that contains Id, Text and geography coordinates. ...CREATE TABLE [Point] ( [Id] INT IDENTITY CONSTRAINT [PK_Point_Id] PRIMARY KEY, [Coords] GEOGRAPHY NOT NULL, [Text] NVARCHAR(32) NOT NULL, [CreationDate] DATETIME N...
asked by lenden
Using Dapper.net to call stored procedure, always return -1 back
here's my stored procedure. when I test it, always get correct result back....ALTER PROCEDURE [dbo].[AddSmoothieIngredients] -- Add the parameters for the stored procedure here @Query NVARCHAR(4000) , @SmoothieId INT , @CreatedDate DATETI...
asked by qinking126
How to call UDF with Dapper?
Is there any way to call table-valued UDF with Dapper, except:...var rows = connection.Query("select * from My_UDF(@a,@b)", new {a=1, b=2 }); ...I prefer to avoid magic strings hence I would like to use something similar to calling SP syntax....I use MS S...
asked by yegor.n.a
Dapper GridReader already Disposed Error
I'm using Dapper dot net to execute a stored procedure that returns 4 result sets. Here's how I'm doing it:... public Results Search(Query query) { if (query == null) throw new ArgumentNullException("query"); Results results; ...
asked by Ronnie Overby
Return Values from Dapper.net query with stored procedure
I am trying to call a stored procedure ...using Dapper.Net... and get return values....p.Add("@INCIDENT_ID", dbType: DbType.Int32, direction: ParameterDirection.ReturnValue); var retResults = con.Execute("usp_GetIncidentID", p, commandType:CommandType.St...
asked by yellowfever
How can I create 1 or 2 objects per row with dapper?
I have a row with 4 columns of data. I want to create an object A from data in columns 1-2. If the data is not present in columns 1-2, use columns 3-4 to create an object B. In rare cases, we will have data in all columns, but data in columns 2 and 4 does...
asked by MarcusMartin
Page 1 of 15