/*
Author: Jiangong SUN
*/
Deferred Execution is used in LINQ, and it means the query is not executed when declaring it; but when calling it.
If you return IQueryable or IEnumerable in your query, the query will not be executed immediately, it will be executed only when you iterate its elements.
But if you return operations on IQueryable or IEnumerable like .ToList(), Count() etc, it will be executed immediately.
Let's see some examples:
public void EnumerableCustomers()
{
int id = 10;
//differed execution: when query returns IEnumerable or IQueryable
var query = from c in Context.Customers
where c.CustomerId > id
select c;
id = 20; //this value is finally used because it's the latest value
Console.WriteLine("Query result:");
//return customer names whose id is larger than 20
foreach (var customer in query)
Console.WriteLine(customer.CustomerName);
}
private void EnumerableCustomers2()
{
int id2 = 10;
//immediate execution: when query doesn't return IEnumerable or IQueryable
var query2 = (from c in Context.Customers
where c.CustomerId > id2
select c).ToList();
id2 = 20; //this value is not used in this case
Console.WriteLine("Query2 result:");
//return customer names whose id is large than 10
foreach (var customer in query2)
Console.WriteLine(customer.CustomerName);
}
I hope this article can do help to you! Enjoy coding!
references:
http://blogs.msdn.com/b/charlie/archive/2007/12/09/deferred-execution.
aspx
early binding, late binding:
http://blogs.msdn.com/b/cburrows/archive/2008/10/27/c-dynamic.aspx
