Dapper Tutorial - Knowledge Base (KB)

Dapper to insert multiple rows into two tables using stored procedure

I am using Dapper (...https://github.com/StackExchange/Dapper...) in asp.net core myweb api project. I have a requirement to create a master record and insert a set of rows into a child table....Ex. OrdersMaster table create an order id in this table ...

Does ASP.NET Core WebAPI not support deferred execution / lazy evaluation when returning collections?

I've just run into what I'd consider a slightly odd bit of behaviour when writing a C# ASP.NET Core WebAPI controller....Consider the following controller method, which accepts a JSON body and produces an XML output (for reasons I won't go into):...[Produ...

Dapper changing connection string at runtime

I have three identical database servers (DDL wise) that my application connects to....I want let application users decide which database they want to connect to....This is a ASP.NET Core 2.1 API project, which implements both service and repository patter...