Hi, Am very thankful to this forum.This is helps to me in implementation.I have implemented Bulk insertion as you suggested with Custom Repository and my code is public Task InsertBulkList(List<Entity> input) { return Task.Run(() => { using (var transactionScope = new TransactionScope()) {
var options = new BulkInsertOptions
{
EnableStreaming = true,
};
Context.BulkInsert(input, options);
Context.SaveChanges();
transactionScope.Complete();
}
}
);
}
Am getting Error Like "An exception of type 'System.Collections.Generic.KeyNotFoundException' occurred in EntityFramework.BulkInsert.dll but was not handled in user code". So please help me to solve this problem".
Thanks a lot