How to do a Bulk Insert -- Linq to Entities

c# asp.net-mvc entity-framework linq-to-entities
Luke101 picture Luke101 · Oct 22, 2009 · Viewed 36.4k times · Source

I cannot find any examples on how to do a Bulk/batch insert using Linq to Entities. Do you guys know how to do a Bulk Insert?

Answer

Marc Gravell picture Marc Gravell · Oct 22, 2009

Sometimes you simply have to mix models. Perhaps use SqlBulkCopy for this part of your repository (since this plugs directly into the bulk-copy API), and Entity Framework for some of the rest. And if necessary, a bit of direct ADO.NET. Ultimately the goal is to get the job done.

Related questions

Semaphore exception - Adding the specified count to the semaphore would cause it to exceed its maximum count

I've been having this SemaphoreFullException for quiet some time. To summarize.. I have hosted an application on IIS 7.5 with ASP.NET v4.0 framework Application Pool (integrated). I am using windows authentication to authenticate my users through domain (isinrole). I've seen …

Read More
Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework

I want to save my Edit to Database and I am using Entity FrameWork Code-First in ASP.NET MVC 3 / C# but I am getting errors. In my Event class, I have DateTime and TimeSpan datatypes but in my database, I've …

Read More
Value cannot be null. Parameter name: source

This is probably the biggest waste of time problem I have spent hours on solving for a long time. var db = new hublisherEntities(); establishment_brands est = new establishment_brands(); est.brand_id = 1; est.establishment_id = 1; est.price = collection["price"]; est.…

Read More