I had an interview this morning and Entity Framework came up. The guy asked how we can identify why an EF call is slow. I can you can look at the SQL statement it generates. You can step thru the code, grab the SQL it generates. He said EF doesn't do SQL (or something like that).
I also said EF generates complicated SQL statements and brings back columns of data that might not be needed.
I think you can grab the SQL statement EF generates. A couple of years ago, I worked on a project that we would grab the EF's generated SQL.
He also asked how we can improve EF's performance. I said maybe break up the call they're making to get the data.
I think he wanted an answer to take back to his developer. He said he keeps asking his developer why the EF call is slow and the guy says he doesn't know :)