Dapper Tutorial - Knowledge Base (KB)
66 results for: in tag: stored-procedures
Is there a way to call a stored procedure with Dapper?
I am very impressed with the results of ...Dapper Micro ORM... for stackoverflow.com. I am considering it for my new project and but I have one concern about that some times my project requires to have Stored Procedure and I have search a lot on web but n...
asked by Jalpesh Vadgama
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
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
Is there a way to map column names to properties from my entity using Dapper?
I'm considering in using dapper for my project, but first, I need to know if it:...1-) Can it map column name to my class properties? In my project, i have legacy tables that has no cool names....2-) It works well with stored procedures? All my queryes re...
asked by Cleyton
Using Dapper.Net ORM, how do I cast stored procedure output to a concrete type?
Using Entity Framework I can create concrete classes from most of the sprocs in the database of a project I'm working on. However, some of the sprocs use dynamic SQL and as such no metadata is returned for the sproc....So for a that sproc, I manually cre...
asked by ElHaix
Does Dapper support strongly typed objects with a stored procedure?
Basically, I want to use the "nice" Dapper syntax for a stored procedure, without having to manually use ...exec MySproc @p1, @p2, @p3, @p4... and so on, but I need to be able to pass in a strongly typed object with various properties set and have this ob...
asked by Wayne Molina
How to return null from a Dapper query rather than default(T)?
I'm using ...Dapper... for some read-only database calls via a stored procedure. I've got a query that will either return 1 row or nothing....I'm using Dapper like this:...using (var conn = new SqlConnection(ConnectionString)) { conn.Open(); retu...
asked by James Simm
Dapper stored procedures with Postgresql without alphabetical parameters
I am trying to call a Postgresql stored procedure written in plpgsql using C# and Dapper, but I have found that Dapper alphabetizes the parameters before inserting them into the stored procedure. Is there a way I can avoid this behavior and have the items...
asked by CookieOfFortune
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
Dapper (connection.Query or connection.Execute)
I see the example of using Dapper in executing stored procedures with dynamic parameters, and returning the results of the procedure. Usually, the examples use .Execute, but a few of them use .Query. I have difficulty in using .Execute. Which am I supp...
asked by Kevin Earley
Error thrown when executing a stored procedure that returns no results
I am currently using dapper on one of our projects and we execute stored procedures all the time. In the first few methods everything was working fine when the stored procedure we execute returns rows....Right now I'm facing an issue when I try to fetch d...
asked by rocco
Dapper with multimapping using stored procedure
This is regarding Dapper in ASP.NET MVC3....I have two tables ...tblBranchMaster..., ...tblZoneMaster... in my database and two class file with same details....tblBranchMaster(ID, ZoneID, Name); tblZoneMaster(ID, Name); ...Both table having primary ke...
asked by Sham
ServiceStack MARS (Multiple Active Result Sets) using ORMLite and Output Parameters
ServiceStack ORMLite is great, I've typically steered clear of the ORM mentality preferring to build databases as it makes sense to build databases instead of a 1:1 class model. That said, there are a couple of things that I seem to be running into diffi...
asked by Ram Argid
Dapper getting "Specified cast is not valid." for ReturnValue parameter value
I am trying to use SCOPE_IDENTITY to return a long primary key back to c# using the ReturnValue option for DynamicParameter....Here is sample code from the Dapper website: ...var p = new DynamicParameters(); p.Add("@a", 11); p.Add("@b", dbType: DbType....
asked by user1790300
Dapper mapping column with a property in the model having a different name and type
I have a model this model: ... public class Member { #region public property public int Id { get; set; } public string LastName { get; set; } public string FirstName { get; set; } public AccountState AccountSta...
asked by user1428798
How to get flat record set back from stored procedure in Dapper.Net
I've got a project running on SQL Server 2005. I have a stored procedure that accepts some input parameters, has 2 output parameters and also returns a result set from a select statement inside....The data is not intending to be returned back as objects j...
asked by Jafin
Call stored procedure from dapper which accept list of user defined table type
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...
asked by imodin
Dapper - splitOn doesn't exist
I'm trying to execute this snippet...var dParams = new DynamicParameters(); dParams.Add("@ShipDate", warranty.ShipDate); dParams.Add("@WarrantyStartDate", warranty.WarrantyStartDate); dParams.Add("@WarrantyEndDate", warranty.WarrantyEndDate); dParams.Add...
asked by user1021726
Dapper: Can I query two stored procedures into one object
I have this:...public class Item1 { public string Value1; public string Value2; } public class Item2: Item1 { public string Value3; } ...I want to query two stored procedures, one returns Value1 and Value2, and the other returns Value3. I'm ...
asked by Escobar5
Mapping fields in stored procedure to class properties with different names with Dapper
I have this exert from a POCO class with many fields:...public class Call { public int Id { get; set; } public string Customer { get; set; } public int StatusId { get; set; } public int UserAssignedToId { get; set; } public string User...
asked by mjbates7
Page 1 of 4