Fix Linq performance issues for enterprise users in .NET 4.0?

Question

Now I feel quite comfortable with the infrastructure of the entity. I read some articles on Linq to Entities performance efficiency. Are these problems still present in .NET 4.0?

Answer 1

The performance of the Entity Framework is much better in EF 4.0 than in previous releases.

However, many (most?) EF performance issues are related to the specific ADO.NET Entity Framework Provider that you are using. It is the provider that processes the requests in a way that works well for this database engine. SQL Server works well - many other providers are not so good.

This is also true in the current version of EF. For example, some of the providers create much more database queries than necessary, which becomes especially problematic in 3.5 due to the way EF accesses data in certain cases.