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...
I am experiencing issues when trying to used a paramaterized query in Dapper. I have found a number of other users with similar issues but have not been able to resolve the issue....The code... public User GetUser(int employeeId)
{
var args...
I've been using Dapper to call stored procedures passing it an object. For example:...If I have an object:...public int ID { get; set; }
public int Year { get; set; }
...I can create this object and pass it to my ...Execute... call as the parameters. ...
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... ...
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 ...
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...
I want to map complex object to dapper result from query which has two inner joins. I know we've solution to map one inner join but I want to map two inner joins result....Here is the Scenario:...My Classes are:...public class Order
{
public int id {...
I'd like to insert a list of objects in an SQL table....I know this question ...here... but I don't understand....Here is my class :...public class MyObject
{
public int? ID { get; set; }
public string ObjectType { get; set; }
public string C...
We're running into an issue were we execute a large number of queries at once (large being 100-200) using Dapper async and end up getting timeout exceptions. I think what is happening is that Dapper is doing ...await ... [connection].OpenAsync(...)... (..
I have written stored procedure which return two result sets.
and I have called stord procedure from C# code by dapper API...like this ...var Count= result.Read<int>().ToList().FirstOrDefault();
var Employees= result.Read<EmployeeData>().ToList();
...the ...
I have a c# mvc app using Dapper. There is a list table page which has several optional filters (as well as paging). A user can select (or not) any of several (about 8 right now but could grow) filters, each with a drop down for a from value and to valu...
I just started learning Dapper in C# but I am having difficulty in executing stored procedures with two or more SQL Statements in one transaction....How do you get the output parameter of a Stored Procedure that
contains both Insert and Select statement...
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...
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)
...
In C#, I use Dapper to interact with SQL Server. I call a stored procedure that accepts 2 user-defined tables as parameters....And I am passing a ...DataTable... to my stored procedure. According to this ...page..., the syntax to pass a ...DataTable... is...