This was posted in an internal discussion. The question was that it was observed that sometimes in the generated sql it appeared that EF was very decisive between directly executing the query and sometimes using sp_executesql. Before I go ahead and...

I was a little curious about this change in EFv4 and wanted to understand why this was done. So here is what I was able to understand Background Lets take a look at the following code for querying the EntitySet in EF v3.5 using (NorthwindEntities...