Is the ADO.NET Entity Framework known for generating poorly performing queries?
6
votes
3
answers
1593
views
This question is inspired by the comment posted to the latest ServerFault blog post :
> Are you guys still using LINQ to SQL?
I know I can use SQL Server Profiler and/or the
ToTraceString
method to see the generated queries and analyze them myself. However, I am looking for opinions from **people with hands-on experience with administering databases accessed by applications utilizing the Entity Framework**.
Are Entity Framework queries a common cause of performance problems?
Can LINQ queries be optimized in such cases or is raw Transact-SQL the only solution?
Asked by Marek Grzenkowicz
(1495 rep)
Feb 15, 2011, 09:02 PM
Last activity: Feb 4, 2021, 08:36 AM
Last activity: Feb 4, 2021, 08:36 AM