CODEWITHSUNDEEP
c#.netlinq-to-sql
Adam Ritenauer
Adam Ritenauer

Reputation: 3181

When does a compiled query that returns an IQueryable execute?

Okay I need a sanity check here...

I've compiled a query that returns an IQueryable when executed.

On what line(s) should the query actually execute against the database in the following example?

101 IQueryable<T> results = MyCompiledQuery(MyDataContext);
102 List<T> final = (from t in result
103                  where t.ID > 5
104                  select t).ToList<T>();

Here is how I define the compiled query

 public static Func<MyDataContext, IQueryable<Widget>> MyCompiledQuery=
        CompiledQuery.Compile<MyDataContext, IQueryable<Widget>>(
                      (MyDataContext db) =>
                      from w in db.Widgets
                      where ((w.Type == WidgetType.Atype ||  //Widget.Atype is a Linq to Sql object, that I've defined statically
                              w.Type == WidgetType.Btype ||  //See above comment
                              w.Type == WidgetType.Ctype ) && //See above comment
                              w.Location == WidgetLocation.Domestic)  //Samething applies here
                        select euc);

FOR ADDITIONAL DISCUSSION PLEASE REFER TO: LINQ to SQL compiled queries and when they execute

Upvotes: 8

Views: 7538

Answers (5)

Dux
Dux

Reputation: 9

As far as I know IQueryable never gets executed it just converts the Linq query to a queryable format so that it gets executed whenever its requested.

In this case I guess the moment its asked to convert to a List it queries the result. And no point in fight about line 102 and 104 as both represents a single line.

Upvotes: 0

alex
alex

Reputation: 75945

"On the line 104, when doing ToList conversion."

Well, this answer is incorrect. We invoke delegate stored in MyCompiledQuery variable on line 101 that returns the result of the compiled query, not the query itself.

Upvotes: 2

lahsrah
lahsrah

Reputation: 9173

This Query executes on line 101. I verified it by doing a SQL Profiler trace. I guess this is because it is a compiled query.

The filtering you are doing afterwords > 5 is done in memory.

Upvotes: 3

Sani Huttunen
Sani Huttunen

Reputation: 24385

This is called Deferred Execution.
You can read a good post on it here.

Upvotes: 0

Alan
Alan

Reputation: 46813

It executes at line 104 (when you call ToList()).

A compiled query is a query that is translated only once to TSQL at compile time, instead of everytime prior to execution.

Upvotes: 3

Related Questions