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.


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.

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

I've reimplemented the function in this SO post:

bulk insert with linq-to-sql

Related Articles