score:3

Entity framework (and Linq-to-entities) has no support for bulk inserts. Bulk inserts must always be done through native features of database server. To use LOAD DATA INFILE from .NET Connector check MySqlBulkLoader class.

score:-1

This post looks promising. I'm giving it a try in my own application. Plus, it doesn't interfere with your designer since it is a partial class.

http://www.codeproject.com/Tips/297582/Using-bulk-insert-with-your-linq-to-sql-datacontex

In addition, here's a class on MSDN that does the same thing:

http://archive.msdn.microsoft.com/LinqEntityDataReader

I've reimplemented the function in this SO post:

bulk insert with linq-to-sql


Related Articles