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

What are the advantages of a compiled query?

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