Entity Framework queries speed

Question

Recently I started to learning Entity Framework.

First question made in my mind is:

When we want to use LINQ to fetching data in EF, every query like this:

var a = from p in contacts select p.name ;

will be converts to SQL commands like this :

select name from contacts

1. does this converting repeat every time that we are querying?
2. I heard that stored procedures are cached in database, does this event happens in LINQ queries in Entity Framework ?

And at last is my question clear?

Answer 1

I think linq query is converted each time you want to execute it. To improve performance you can use compiled queries.

Answer 2

There are all sorts of optimizations being made, both in the linq expression caching and what SQL server chooses to cache, the only way is to measure your performance speed and memory consumption

To see what SQL is created you can use http://efprof.com/ which I've found quite good. You can get some of this info through SQL profiler, it's just a lot more work.