Dapper Tutorial - Knowledge Base (KB)

Attribute routing not working with dictionaries

Being new to attribute routing, I'd like to ask for help getting this to work....This test is a simple dynamic DB table viewer: Given a table name (or stored query name or whatever) and optionally some WHERE parameters, return query results....Table COMPA...

Dapper Query Return Error

I'm working on MVC Web API with Dapper version 1.38.0.0. I write this code... var param = new Dapper.DynamicParameters(); foreach (Match match in Regex.Matches("Select Top @count * From tblCourse", @"(?<!\w)@\w+")) { string key = match.Value; ...

Dapper needs a parameterless constructor?

I have a class:...public class NListingsData : ListingData, IListingData { private readonly IMetaDictionaryRepository _metaDictionary; //Constructor. public NListingsData(IMetaDictionaryRepository metaDictionary) { ...

Dapper giving "Invalid attempt to call FieldCount when reader is closed." when trying to use "QueryMultiple"

I have a wrapper method for Dapper.NET's ...QueryMultiple... method. It successfully gets data from a Stored Procedure, which has 3 queries, all of them are ...SELECT... queries. But after getting the data, I cannot use ...Read... or ...ReadAsync... to as...

provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server, pgsql

I am using Dapper to connect to pgsql database. The below code was working few days back. But don't know why its not working now. The same credentials are working with pgadmin3 but not with the c# code. here is the controller method, for simplicity I wro...

Map lists of nested objects with Dapper (3 level nested object)

I'm using Dapper and I have classes like this:...public class Region { public Region() { Countries = new List<Country>(0); } public int RegionID { get; set; } public int RiskRank { get; set; } public string Name { get; se...

Dapper connect to Oracle exception The value's length for key 'data source' exceeds it's limit of '128'

I would like to use Dapper to establish a link for my WebApi. But I got this error below:...The value's length for key 'data source' exceeds it's limit of '128'...The cause of this error is this line:...IDbConnection db = new SqlConnection(ConfigurationMa...

Why did my async with ContinueWith deadlock?

I'm not after a solution here, more an explanation of what's going on.... I've refactored this code to prevent this problem but I'm intrigued why this call deadlocked. Basically I have a list of head objects and I need to load each ones details from a DB ...