Query and manipulate data by using the Entity Framework - ADO.NET

What are the advantages of a compiled query?

The translation of your query into SQL is cached.
None. Every time you run the query you will hit the database.
None. You can’t change any of the parameters you use in a query, rendering the compiled query useless.
The results of the query are cached making the querying a lot faster.