Dapper Tutorial - Knowledge Base (KB)
68 results for: in tag: stored-procedures
c# dapper stored procedure returning null
Everything I try to do it just keeps spiting out null. This is the method that gets the data...public List<Item> getItems(string item_name) { using (IDbConnection connection = new MySqlConnection(Helper.CnnVal("dbConn"))) { connection.Open...
asked by JimmyNeutron
Dapper - call Oracle schema.package.function
I can call Oracle stored procedure and function with Dapper, but I have problems with calling a function inside of package. ...My error is:...ORA-06550: line 1, column 39: PLS-00302: component 'funct' must be declared ORA-06550: line 1, column 7: PL/SQL: ...
asked by goran85
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
How to use Dapper asynchronously with multiple stored procedure calls?
I'm using the Dapper ORM in an ASP.Net Core 2.1 CRUD application, with a SQL Server database. For a new form I'm developing, I want to retrieve all reference data (to populate ...SELECT... field options) in one go when the screen is invoked. This involves...
asked by Cass
Dapper - Pass list of int to stored procedure
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...
asked by Chatra
C# SQL Server stored procedure parameter return list
I'm attempting to execute a SQL Server stored procedure that takes two parameters and returns a list of results. The application is returning the results however I'm unsure how to assign the values to the list in the model. The ORM being utilized is Dappe...
asked by Gonzo Nick
When calling a T-SQL stored procedure with Dapper do I need to use '@'?
I am want to call a stored procedure with Dapper and all the code I've seen so far does this by specifying the stored procedure parameters with the @ character. This means that I cannot simply define a model class and pass it into Dapper's Query or Execut...
asked by Matt W
How to have Dapper iterate a stored procedure for inserts?
I have the following Dapper command to insert values into a table using a stored procedure....sqlConnection.Execute( "sp_LocationTypes_Insert" , parameters , commandType: CommandType.StoredProcedure ); ...where the parameters a...
asked by ChrisP
Query already has answer?
My stored procedure has an output parameter for row count. When the stored procedure is called using Dapper......var p = new DynamicParameters(); p.Add("@rowCount", dbType: DbType.Int32, direction: ParameterDirection.Output); var reader = conn.ExecuteRea...
asked by Ian Warburton
Pass an array of complex objects to a stored procedure with dapper
I am assisting someone on a dapper related integration and there is currently a scenario where we have some data that we need to get into a stored procedure. So we can write the stored procedure however we want, and can write the dapper bit however we wan...
asked by Grofit
Dapper or MySql not finding stored procedures that contain a full stop "."
I've got a simple c# console that uses the Dapper ORM to make a call to a local MySql database in order to execute a stored procedure called ...users.UserCreate.......However, when running the query I get an exception saying ...Procedure or function 'User...
asked by Dezzamondo
Pass table-valued parameter to a stored procedure
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...
asked by Rahul
reusing the connection string for stored procedure
I have code using EF with a connection string as in web.config (spaces and line breaks for clarity) :...connectionString= metadata=res://*/Models.XXXDataContext.csdl| res://*/Models.XXXDataContext.ssdl| res://*/Models.XXXDataContext.msl;...
asked by waitforit
Stored procedure is not returning rows with dynamic query, Dapper
I've created a stored procedure with dynamic query. The values are returned to my app in C# with Dapper....The following code works, the rows are returned to my app and are shown in SQL Server....set @query = 'Select * from invoices'; exec sp_executesql @...
asked by Magux
How to call a stored procedure with a mixed-case name from Dapper (with Npgsql)?
From NuGet, I am using......\packages\Npgsql.2.2.5\lib\net45\Npgsql.dll......\packages\Dapper.1.42\lib\net45\Dapper.dll...In calling a stored procedure in PostgreSQL, I have need to preserve the ...case of the procedure name... as...var x = cnn.Query<icd9...
asked by Alan Wayne
Azure SQL Database: "No columns were selected" when calling a stored procedure using Dapper
I have a really simple stored procedure in Azure SQL Database:...CREATE PROCEDURE dbo.spfindPartialIdentity @ClientId nvarchar(50), @ExternalId nvarchar(250) AS BEGIN SET NOCOUNT ON; SELECT ClientId, ExternalId FROM [db...
asked by Jose Parra
Map navigation properties in Dapper.Net using stored procedure
I am using Dapper.Net to get data from SQL Server database....Here is my POCO classes...public partial class Production { public System.Guid ProductionId { get; set; } public System.Guid SurveyId { get; set; } public Nullable<int> PercentCompl...
asked by Ghazanfar Khan
Dapper function doesn't map the string values from stored procedure, but maps the other values correctly
I have a stored procedure which returns data in the following format:..."CompanyId"|"MetadataId"|"Mnemonic"|"Short"|"format"|"MetaDataType"|"lngValue"|"decValue"|"charValue"|"dateValue"|"blnValue"|"sOrder"|"version"|"Type"|"SortOrder"|"createdDate" ...The...
asked by Gurkmeja101
Dapper - Stored procedure oracle doesn't return result, if more two OUT parameters
Can help me. I don't get result in My code? if I'm using Dapper....using(var connection = new OracleConnection("User ID=TEST;Password=TEST;data source=R_TEST")) { connection.Open(); var p = new OracleDynamicParamet...
asked by ÐÑ€Ñений Савин
ASP .Net Identity, Dapper & stored procedures Best Practices
I am currently following this ...guide... to learn Dapper micro ORM and ASP.NET identity. I thought to mix it up a bit by implementing a generic repository pattern that will help me do basic CRUD operations....Here are my classes:...User.cs...public class...
asked by Nick
Page 1 of 4