Grant,

EF does JOINs exactly like we do in T-SQL.

Example: There are two tables in AdventureWorks database, Employee and Contact. Each Employee can have more than one contact but Contact's...

Thanks Noel and Grant,

I looked at the Execution plan and it was identical.

I still wonder why would Microsoft's EF engine create queries like this and is there any memory...