Performance

Hi,

The Entity Framework and LINQ integration, just like any other higher-level abstraction, introduces certain amount of overhead to the system. So typically you can expect it to be somewhat slower than using the lower-level ADO.NET APIs directly (e.g. datareader). Given that productivity and expressivity gains, this trade-off typically works well.

The August CTP did not include most of the performance work that we're planning to do to make sure performance is at an appropriate level. In future iterations we'll include more of the performance optimizations we're working on and you should see performance going up considerably.

Regarding the overhead of LINQ to Entities compared to using the Entity Framework with Entity SQL, we're still analyzing the perf characteristics of each one, but you can expect that the difference should be very, very small, if any.

Pablo Castro
ADO.NET Entity Framework
Microsoft Corporation

pablo-ms at 2007-8-31 >