To the last point linq/ef actually generates one SQL query for whatever you are doing if you use it properly.