Dapper Tutorial - Knowledge Base (KB)

Dapper - Bulk insert of new items and get back new IDs

I am using dapper to add multiple new students in one db hit using this method:...db.ExecuteAsync(@"INSERT Student(Name,Age) values (@Name,@Age)", students.Select(s => new { Name = s.Name, Age = s.Age }) ); ...But the problem I don't have the new ids. ...

best way to do bulk inserts using dapper.net

I am using the following code to insert records to a table in SQL Server 2014...using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["myConnString"])) { conn.Execute("INSERT statement here", insertList); } ...The ...insertLi...

How to use Dapper for bulk insert with foreign keys?

I have a C# data structure like so:...public class Invoice { public string InvoiceNumber {get;set;} public List<SalesPerson> SalesPersons {get;set;} } public class SalesPerson { public string Name {get;set;} } ...This corresponds to two table...

How to bulk insert in SQL using Dapper in C#

I am using C# Dapper with MYSQL. ...I have a list of classes that i want to insert into MySQL table. ...I used to do it using TVP in MS SQL, how do we do it in MySQL.