Do Not Blindly Generate Crud Queries

Create, Read, Update, and Delete (CRUD) queries can all be generated from the ORM tool without the need for intervention. But, the Read queries generated are frequently very inefficient. Consider writing a stored procedure for complex Read queries.

50 Ways to Avoid Find and Fix ASP.NET Performance Issues