Dapper Tutorial - Knowledge Base (KB)

Bulk inserts taking longer than expected using Dapper

After reading ...this article... I decided to take a closer look at the way I was using Dapper....I ran this code on an empty database...var members = new List<Member>(); for (int i = 0; i < 50000; i++) { members.Add(new Member() { Usernam...

How to use SQL Bulk Copy with Dapper .Net ?

I am working with Dapper .net for Bulk insert operation in SQL Tables. I am thinking to user SQKBulk copy with Dapper .Net but don't have any experience How to use SqlbulkCopy with Dapper .Net...your help is Highly appreciated

Is SqlBulkCopy still faster than Dapper?

I found an article by Sam Saffron on bulk inserting with ...Dapper... (...That annoying insert problem getting data into the db using dapper...) where he ends the article with the statement:...For example, if you need an ultra fast way to insert lots of s...

Dapper.Net SQL bulk insert decimal precision

I am getting an exception from ...Dapper Bulk Copy... Looks like the underlying bulk copy operation is failing. I dumped the data in json and found the value creating problem is ...259815703.3430760631...StackTrace: at System.Data.SqlClient.SqlBulkCopy.Co...