Export (0) Print
Expand All

DataLoadOptions.LoadWith Method

Retrieves specified data related to the main target.

This member is overloaded. For complete information about this member, including syntax, usage, and examples, click a name in the overload list.

  NameDescription
Public method LoadWith<T>(Expression<Func<T, Object>>) Specifies which sub-objects to retrieve when a query is submitted for an object of type T.
Public method LoadWith(LambdaExpression) Retrieves specified data related to the main target by using a lambda expression.
Top

Use the LoadWith method to specify which data related to your main target should be retrieved at the same time. For example, if you know you will need information about customers' orders, you can use LoadWith to make sure the order information is retrieved at the same time as the customer information. This approach results in only one trip to the database for both sets of information.

The following snippet shows how to use the non-generic method:

DataLoadOptions options = new DataLoadOptions();
db.LoadOptions = options;
options.LoadWith((Customer c) => c.Orders);

In the following example, all the Orders for all the Customers who are located in London are retrieved when the query is executed. As a result, successive access to the Orders property on a Customer object does not trigger a new database query.


Northwnd db = new Northwnd(@"c:\northwnd.mdf");
DataLoadOptions dlo = new DataLoadOptions();
dlo.LoadWith<Customer>(c => c.Orders);
db.LoadOptions = dlo;

var londonCustomers =
    from cust in db.Customers
    where cust.City == "London"
    select cust;

foreach (var custObj in londonCustomers)
{
    Console.WriteLine(custObj.CustomerID);
}


Community Additions

ADD
Show:
© 2014 Microsoft