Dapper Tutorial - Knowledge Base (KB)

Simple dapper select query with 20 rows(most of columns are nvarchar(max)) taking too long- 15 seconds and more

My dapper code is given below with a select query:...const string Sql = @"SELECT [id] ,[groupName] ,[reqCap] ,[impCap] ,[player] ...

C# Displaying returned parameter as decimal within a label

I am using a returned parameter to display the weight of a bin....Here is my SQL Server stored procedure;...ALTER PROCEDURE [dbo].[SumScrapBinWeight] @ScrapBinNumber INT, @ScrapBinWeightSUM DECIMAL(8,2) OUTPUT AS BEGIN SELECT @ScrapBinWeightS...

"Procedure expects parameter which was not supplied..." SQL Trace indicates procedure gets the parameter

I am at a loss here, I don't understand why the procedure is not getting this parameter......Procedure (...procInfoColor...):...ALTER PROCEDURE [dbo].[procInfoColor] (@ID int) AS BEGIN SELECT Id, Code, [Description], IsActive FROM tblColor WHERE I...