When creating an application with an ORM framework, such as Entity Framework, it’s a good idea to look at the SQL that’s actually being sent to the server. This is a critical step that can be easily overlooked.
Why is it important to look at the SQL? Well, if we don’t look at the SQL, then we can end up with queries that join ten different tables and return rows with more than 100 columns. Unless your machine has unlimited resources, then we should strive to keep our queries resource-friendly.