Stack Overflow
Stack Overflow

Questions tagged [ef-bulkinsert]

EntityFramework.BulkInsert is an extension for Entity Framework that allows users to insert large amounts of data faster than with a regular insert

EntityFramework.BulkInsert is an extension for Entity Framework that allows users to insert large amounts of data faster than with a regular insert. It's project homepage on Codeplex exists here. It already ships with common providers for databases like SQLServer and Oracle, but also can be extended to use custom implementations. It supports advanced features like transactions and streaming of data.

The documentation for using EntityFramework.BulkInsert can be found here.

19 questions
4
votes
1 answer

EF.BulkInsert and Glimpse - not playing together well

I have an EF6 / ASP.NET 4.5 Webforms solution up and running, and now I need to add some functionality to allow bulk inserts from Excel files. I am aware that EF out of the box isn't optimized for bulk operations, so I looked around and found "EF…
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
3
votes
0 answers

Asp.net core identity bulk insert users

I am using https://github.com/borisdj/EFCore.BulkExtensions for bulk inserting data into database for better performance. Now I want to do the same while adding users in AspNetUsers table via userManager.CreateAsync() method, Any suggestions?
Rushi Soni
  • 1,088
  • 1
  • 13
  • 21
3
votes
4 answers

Bulk insert is not working properly in Azure SQL Server

I'm not able to insert the bulk amount of data into Azure SQL server DB using C# webapi Consider I want to insert 60K> data in SQL. In my local sql server there is no problem but in Azure SQL its getting connection timed-out My approach:(All are…
Sreemat
  • 616
  • 10
  • 28
3
votes
2 answers

Bulk insert from a csv file using Entity Framework

I want to do bulk insert from a csv file into the MS SQL Server database using entity framework. Is there any inbuilt method for Bulk Insert using Entity Framework? Thanks
Satyajit
  • 1,971
  • 5
  • 28
  • 51
2
votes
0 answers

Entity Framework extentions bulkinsert ignores set timeout

We are trying to insert a large dataset (2+ million records) into our database, using Entity Framework bulk insert. The extensions is EntityFramework.BulkInsert.Extensions (nuget EntityFramework.BulkInsert-ef6) Version 6.0.2.8. We are using this…
Vincentw
  • 164
  • 3
  • 17
2
votes
2 answers

C# & EF: bulkinsert related objects

I am currently playing with EntityFramework.BulkInsert. While it really helps with performance of simple inserts (16 seconds with 1.000.000 rows) I can't find any information about inserting objects mapped over multiple tables. The only thing…
Daedan
  • 79
  • 7
1
vote
1 answer

Bulk insert with child entities using the EF extension saving duplicate records

I'm doing a bulk insert of an entity with related entities and I need to avoid saving duplicate records. Unfortunately, all entities are getting saved even if they already exist. I'm using the EF extensions library here. This question is a possible…
Yusuff Sodiq
  • 815
  • 2
  • 12
  • 19
1
vote
1 answer

No table mappings provided

I am currently using EntityFramework.BulkInsert-ef6-ext by hugocl. My software is currently running daily and I am getting "No table mappings provided." once in a while, around 1 to 2 times a week while the rest of the days it runs fine. Below is…
vylor
  • 11
  • 4
0
votes
1 answer

Question about performance of the code that uses async await to read several bulk data from Redis and write them to SQL Server in parallel

I wrote the code that reads bulks of data from Redis and writes those bulks to SQL Server using async await in C#. I have written the following code in my TeamController class using async/await to make reading from REDIS in parallel with writing to…
Shahrzad Abedi
  • 11
  • 1
0
votes
2 answers

EntityFramework.BulkInsert: context does not contain a definition for BulkSaveChanges

I'm using EF 6.1.3 and installed EntityFramework.BulkInsert-ef6. context.BulkSaveChanges(); gives me an error context does not contain a definition for BulkSaveChanges I'm forgetting a configuration? Reading…
Massimo Variolo
  • 4,669
  • 6
  • 38
  • 64
0
votes
1 answer

c# bulkinsert MSSQL Object reference not set to an instance of an object weird issue

I've got a weird issue I've been trying to solve. BulkInsert works in one database but not another, even with identical tables. Visual Studio 2017, c#. I've used reverse poco to build the entity framework files. The SQL table in each db consists of…
Jim
  • 117
  • 1
  • 14
0
votes
1 answer

Using BulkInsert with OracleDB

I have some kind of promblem with BulkInsert on my OracleDB. I need to insert couple of thousand objects so I decided to use EF.BulkInsert.Oracle added by Nuget which is extension of EF6.BulkInsert for Oracle. private IOracleDbContext…
Orzel94
  • 93
  • 1
  • 1
  • 8
0
votes
1 answer

Xamarin Froms Bulk data insertion hangs application

I have added data sync in my application. When the application is installed, it prompts the user to sync data. During my testing, i had limited amount of records and it was working fine. Now that I have attached the real database, the app hangs and…
Ahmad Chishti
  • 111
  • 10
0
votes
1 answer

how to get Identity Value for each iteration bulk insert

List< IletisimLog> bulkInsertIletisimLog = new List(); //there are 1000 values in the array of paramaters foreach (var kId in paramaters) { var iletisimLogInsert = new IletisimLog() { KullaniciID = kId.KullaniciId, …
mustafaerdogmus
  • 111
  • 1
  • 2
  • 9
0
votes
1 answer

Insert into Table got really slow after having millions of records

I have a table structure which basically looks like this: UserItems <= Users => UserTransactions The UserItems and USerTransactions tables contain UserId FK in both of them which are indexed. The two of these tables both contain millions and…
User987
  • 3,663
  • 15
  • 54
  • 115
1
2