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
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:
- How to do Bulk Insert using MySQL (like SqlBulkCopy) with Linq to Entities
- Using my own method with LINQ to Entities
- Is ToList required when using foreach with LINQ to Entities
- Like operator or using wildcards in LINQ to Entities
- Problem with LINQ to Entities query using Sum on child object property
- LIKE with Linq to Entities
- LINQ to Entities using the SQL LIKE operator
- Using an IEqualityComparer with a LINQ to Entities Except clause
- How to read a string with UTF8 coding using linq to entities
- Insert a copy of existing row using Linq to Entities
- Linq sub query when using a repository pattern with EF code first
- Linq to Entities - insert all objects with TagID in string into an ICollection<Tag>
- How can I fetch child entities as DTO in parent using reusable queries/Expression's with EF code first?
- Can't add a new record with an integer value into database by using linq from code C#
- Insert Record into two tables with one to many relation by using linq to ado.net entity froamwork
- Call REGEXP_LIKE using LINQ to Entities with Oracle
- Using the like keyword with linq
- Compiling Error with LINQ Sorting Code Using List<T>
- Using Dynamic Linq with late bound crm 2015 entities
- How to make types match in LINQ to Entities when using .GroupJoin extension with multiple conditions?
- Querying DataSet with LIKE and OR using LINQ with C#
- Creating object with nested object list using LINQ to Entities
- I need to save the XML file using linq with xml code in C#
- LINQ to Entities Table top 100 with using distinct name
- EF code first: using Linq with many-to-many relationship
- using linq with mysql database in vb.net
- Return entities after intersecting with list of web controls using LINQ
- Accessing entities with navigation properties using Linq in Web Api and EF
- How to get group of records with latest date using Linq to Entities
- Using LINQ to Entities in Insert
- How to abstract a value from an object within an object?
- I have a custom expression program with a lexer, parser and evaluator. How do I LINQ-ify it?
- How to select specific columns in one-to-one relationship table along with few direct columns in Entity Framework Fluent API
- Comparing the dates logic in Linq
- Multiple aggregate functions in one query using Linq to SQL
- LINQ - Grouped list with condition
- Inner Join on Entity Framework
- Populate List Where Contains values (or objects) from another list
- Sort a Query of multi-rows in a row with Linq
- Linq to check if all value from another list exist
- How can i get primary of a new table generated from OrderBy / GroupBy?
- NULL handling in dbcontext and objectcontext
- Why am I getting an IndexOutOfRangeException here?
- Is there any consideration while comparing Enums in LINQ-to-NHibernate or LINQ?
- Entity Framework - Loading Subclass Entities with TPT Setup
- How to get a an object in list with min field value using linq?
- How to Edit data in nested Listview
- removing items from a list based on two properties
- C# Cast list using Linq using Where function
- Why does this combination of Select, Where and GroupBy cause an exception?