Wednesday, 6 January 2016

ASP.NET Tips #63 - Listen to generated SQL

Entity Framework greatly simplifies database access for the developer, but it can also introduce problems when you are writing more complex LINQ to SQL queries.

This may generate poorly-performing SQL, so troubleshooting the generated SQL with tools like SQL Server Profiler or ANTS Performance Profiler is very important.

No comments :

Post a comment