Speeindg up Entity Framework Inserts

SQL bulk insert does not insert values properly into table

As a follow-up to my earlier comment, since you're only missing the first row, it sounds like you need to add ...HDR=No... to your connection string. ...It should look something like this:...Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 8.0;HDR=No'; ...--EDIT ...Please note the added apostrophes....Good luck.

SQLBulk Copy With Related Entities (Entity Framework)

Say I have the below entities. (Heavily Simplified for brevity, but the key properties are included)...public class Crime { [Key] public int CrimeId {get;set;} public virtual ICollection<Victim> Victims {get;set;} public virtual CrimeDetail Detail {get;set} } public class Victim { [Key] public int Vict...

What is best practice for updating server generated entity IDs after a bulk insert?

There are just under a million nodes in an object graph, mostly disconnected, that need to be imported in bulk....The keys are all server-generated. There are several levels of relations, so after each batch is inserted the correct identity keys need to be retrieved to use as the foreign key values in the next batch....What is the simplest way to d...

SQLBulkCopy inserts using Entity Framework with Foreign Key object

So,...Provided your EF user has the ability to alter schema on the database, you can pursue this method of solving the problem:...Add a GUID column to the table...Identify each object in memory by the GUID...Insert the values via bulk Insert including the identifying GUID...Select them back and map them to the inserted GUIDs...Drop the GUID column....

Sql Server - Insert data in one table along with the new auto-incremented inserted ids of another table

I have 2 databases DB1 and DB2. I need to write query to copy data from DB2 to DB1. Both the databases have same table structure....For Example:...CREATE TABLE DB1.Group( GroupID [int] IDENTITY(1,1) NOT NULL, [Company] [varchar](10) NOT NULL, [Description] [varchar](1000) NOT NULL ) CREATE TABLE DB1.Instance( [InstanceID] [int] IDENTITY(1...

Bulk insert into existing table - only insert new rows

I've got a method to get data from existing table in database as DataTable and i want to add new rows to that datatable and then use SQLBulkCopy to only bulk insert the newly added rows and not the already existing rows, do i need to configure this somehow or will it only add the new rows anyway?...var myDataTable = GetExistingTableDataAsDataTable(...

Connection string works for Entity framework but fails on bulk

The problem I am having is that in the Web.Config, I have a connection string which db.database is using, this works fine, I am able to retrieve data from the database no problem, however the problem I am having is when I try to use SqlBulkCopy:...using (SqlBulkCopy bulk = new SqlBulkCopy(db.Database.Connection.ConnectionString)) { bulk.Destina...

Entity Framework selectively save tracked entities from context and bulk insert others

I'm fairly new to Entity Framework. I've come across a scenario where I have my entities:...public class Company{ public int Id { get; set; } public string Name { get; set; } public IList<Project> Projects{ get; set; } } public class Project { public int Id { get; set; } public List<ProjectRecord> ProjectRecords { get; set; } ...

SQL Bulk Insert in C# not inserting values

Here is the sample for reading schema information from Excel (here we read the tablenames - sheet names with tables in them):...private IEnumerable<string> GetTablesFromExcel(string dataSource) { IEnumerable<string> tables; using (OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;" + string.Format("Data Source...

Problem with Entity Framework extensions .BulkSaveChanges - Saving Guid

I'm using EF extension to do ...BulkSaveChanges..., and I'm using SQLite, everything works perfectly, fast saving, etc. The problem I'm having is that when saving Guids, it's as if ...BulkSaveChanges... is converting the Guids to TEXT first before saving, but the data type is BLOB, then when retrieved from the database through DbContext, GUIDs are ...