This strategy also allows SQL Server do some optimization on the retrieval which isn't possible if I retrieve the tables individually. In Entity Framework you add a View to your DbContext object with ...