3

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

Rakesh Gaur
  • 91
  • 1
  • 2
  • 7
  • 1
    This question seems to be too broad. Is there a specific problem you are struggling with? If so, could you show the code of that problem? – Mixxiphoid Mar 16 '15 at 15:22
  • just execute the sql script you have ,using connection.execute(yoursqlquery) – Thorarins Mar 16 '15 at 15:27

1 Answers1

1

It is not good idea to use dapper for bulk insert, because there it will not fast. The better case for this is use of SqlBulkCopy class. But if you want use Dapper for bulk insert, you can find solution here.

Community
  • 1
  • 1
Alex Erygin
  • 3,161
  • 1
  • 22
  • 22
  • SqlBulkCopy is great, but AFAIK only exists in System.Data.SqlClient data provider, so that's an with MS SQL server. Dapper, on the other hand, is data provider independent. – Lucius Mar 27 '19 at 15:16