Entity Framework 4 : Bad performance with SQL Server 2008

c# entity-framework performance sql-server-2008

Question

I'am developing a software based on Entity Framework to handle data in a MS SQL Server 2008 database.

[Trouble 1]

I've just tried to insert some small data (about 2 Mb) from my progam to the database : the performance are very bad ! It takes more than 1 minute to insert these datas !

I've try to generate pre-compiled views, I've got the same results :-(

All my code use a business layer (automatically generated from .edmx file with T4 template) to manage data in a service layer. It is very pratical to navigate in the relations of objects.

How can I improve the performance of these inserts with Entity Framework ?

[Trouble 2]

Also, before inserting data in database with SaveChanges() method, I fill my object context with AddObject() method. I add about 100 000 small objects (about 2 Mb) to my object context with AddObject() : it takes a very long time (more than 10 minutes) !

How can I decrease this time ?

UPDATE

My program must save more than 50 Mb in database in less than 2-3 minutes ? Do you think it will be possible with EF ?

1
3
10/8/2010 5:04:57 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

You could use the Entity Framework Profiler to check what SQL is being generated. This tool has a 30 day free trial. It also claims that it can do "Analysis and detection of common pitfalls when using Entity Framework".

There is also this article on EF tuning

Edit

Based on your edits EF is not the way to go. You need to do a bulk insert in order to get the data in that fast. Have a look at this link where I helped someone reduce load time from 10 hours to 6 mins.

4
5/23/2017 10:33:05 AM

Related Questions

Using SQL Server 2008 and SQL Server 2005 and date time

A quick google points me to what looks like the ...solution.......Open your EDMX in a file editor (or “open with…” in Visual Studio and select XML Editor). At the top you will find the storage model and it has an attribute ProviderManifestToken. This has should have the value 2008. Change that to 2005, recompile and everything works....NOTE: ...
datetime datetime2 entity-framework sql-server-2005 sql-server-2008
asked by Richard Harrison

Data Type for storing document in SQL Server 2008 via Entity Framework

Change the data type of your model to byte[] and it will be all right dude, if you need more explanations please leave a comment....EDIT:...Dude, I had tried it before in Linq to Sql and this time I tried it in EF, in conceptual model of your namely Foo.edmx file your type is Binary(you can open it through open with context menu of Visual Studio an...
document entity-framework sql-server-2008 store types
asked by Jahan

Multiplicity constraint violated SQL Server 2008 - CodeFirst

You are perhaps a victim of the EF Code-First mapping conventions which create automatically a relationship between ...NationAllies... and ...toNation... you don't want to have....If I understand you correctly (but I am not 100 percent sure, if I do), you actually want to have two relationships and you have exposed only one end of the relationship ...
code-first entity-framework sql-server-2008
asked by Slauma

Can I use entity framework with Visual Studio 2008?

Entity Framework shipped with .NET 3.5 SP1. But that's not the latest version (4.1 at this time). And for that you would need VS2010.
c# entity-framework visual-studio-2008
asked by Kris van der Mast

How to read / write geography data using C#, Entity Framework and SQL Server 2008?

I have a form from which the user will be able to enter the latitude and longitude of a certain point on the map. The data will be input as string values. I did some research and found out from various sources that the Entity Framework doesn't support geography data types....How can I parse and/or save the string data to a geography column in a dat...
c# entity-framework geography gis sql-server-2008
asked by Filip Filipović

Running SQL Server CE 4 Queries with Visual Studio 2012 and SQL Server Management Studio 2012

Try using the SQL Server Object Explorer instead of the Server Explorer. That should allow you to do what you wish.
entity-framework sql-server-2012 sql-server-ce visual-studio-2012
asked by Andrew Clear

How to Identify the primary key duplication from a SQL Server 2008 error code?

If you catch ...SqlException... then see its number, the number ...2627... would mean violation of unique constraint (including primary key). ...try { // insertion code } catch (SqlException ex) { if (ex.Number == 2627) { //Violation of primary key. Handle Exception } else throw; } ...MSSQL_ENG002627...This is a general ...
c# entity-framework sql-server
asked by Habib

SQL Server Express 2008, Joins, and Timeout Expired Error Message

Just a guess, but the query runs fast (3 seconds) only when it is cached. Otherwise, it takes a lot longer and exceeds your server timeout setting. Since System.Data.SqlClient is raising the exception, it is likely that the default timeout is only 15 seconds....MSDN: "The default value is 15 seconds"...Alternatively, try the CommandTimeout proper...
entity-framework join sql-server stored-procedures timeout
asked by ExactaBox

Entity Framework 6.1.3 and SQL Server CE 4.0 - No Entity Framework provider found

PROBLEM: I had a website that was working with my local dev machine (VS2013, EF6.1.3, SQl Server CE 4.0, EF Tools installed). I maintain the website using a git repo locally and in VS OnLine....I am at a different (temporary) location with a new machine. I fetched the website from my git repo down to this new machine. All seemed to work OK (coul...
ef-database-first entity-framework-6 git sql-server-ce-4
asked by RRRSR

Offset/Fetch based paging (Implementation) in EntityFramework (Using LINQ) for SQL Server 2008

This is possible with ...Entity Framework 6.1.2... and above so you should be OK to use it in your project. The standard Skip and Take methods can't be captured in the same way as others. There are now two additional overload of the Skip/Take methods that take lambdas, so instead of this:...var results = context.MyTable .Skip(10) .Take(5); ...
entity-framework entity-framework-6 pagination sql-server sql-server-2008
asked by DavidG

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow