SQL : Why does Entity Framework 6 generate complex SQL queries for simple lookups?

Published --