Linked Questions

I want to insert 20000 records in a table by entity framework and it takes about 2 min. Is there any way other than using SP to improve its performance. This is my code: foreach (Employees item in ...

I am running an import that will have 1000's of records on each run. Just looking for some confirmation on my assumptions: Which of these makes the most sense: Run SaveChanges() every AddToClassName(...

I'm working on a project that just inserts relatively large number of records (250K records, just 2 columns) using Entity Framework code-first.. But it takes too much time to write all the records to ...

I have a following setup: Table1 - 150k rows currently, need to add another 25k rows, Table2 - 300k rows, need to add another 50k. I add rows in a loop, like that (EF code first): using (var context =...

I am using EF6 with SQLCE database with few tables which have more than 200K records each. I am trying to update records in one of those tables but unfortunately, the updating process is very slow ...

I have a table with 100,000+ records. Customer has asked that we encrypt the username field, copy the encrypted value to a new field, and clear the original username field. The encryption can only be ...

I have written a class to upload a very large set of data into a database. The foreach loop seems to be slow, taking around 16ms per loop iteration. In what ways could I increase the speed of this ...

I am trying to insert a ton of data into a SQL server database and my question is, how often i should save when millions of entries are going to be inserted there. Is it efficient to save it after e.g....

We have a requirement to read a load of xml files, run validation on them, transform them into entities and stores them in the database. This was being done using a repository wrapping Entity ...

I have a button with a list of users in the table ButtonUsers. A parent Button is updated with the list of users, and all other Buttons' UserList should be updated. This isn't the case every time, ...

I am trying to take all the ids from a table of 1.3 million rows and insert them into another table in another database using Entity Framework. When I do this with SSIS, it is done in under 5 minutes, ...

I am using EF6 in a project. Because of the speed limitations for adding many (i.e. 10,000+) entities via EF6 I have resorted to doing the database additions outside of EF6. The code that does the ...

I am running some correction code that runs over a big pile of entities, as it progress its speed decreases, that is because the number of tracked entities in the context increase with each iteration, ...

I have followed the "Don't Optimize Prematurely" mantra and coded up my WCF Service using Entity Framework. However, I profiled the performance and Entity Framework is too slow. (My app processes 2 ...

I have a block of code that runs within a TransactionScope and within this block of code I make several calls to the DB. Selects, Updates, Creates, and Deletes, the whole gamut. When I execute my ...