Entity SQL Tip #1

A well defined query against a well defined entity data model does not need JOIN.


Navigation properties in combination with nesting sub-queries should be used instead. These latter constructs represent task requirements much more closely than JOIN does. That makes it easier to build and maintain correct Entity SQL queries.  


Comments (0)