Wednesday, September 3, 2008

why Compiled queries(LINQ) are faster?

There are some drawbacks to LINQ to SQL. The Sql statement is built dynamically, so it is needed to parsed and compiled each time you run it. 
System.Data.Linq namespace includes a class named CompiledQuery which is responsible for caching the compiled version of a Linq to Sql query. 
****pre-compiled queries , that you can not use a stored-procedure to make a compiled query.

No comments: