You are implementing a repository method with LINQ to SQL. The method will return a Customer instance with a given identifier. The Customer class includes an Orders property that gives related Order instances. You need to ensure that orders given by the Orders property are retrieved when the Customer instance is retrieved.

What should you do?

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.

Use AssociateWith methods to specify subqueries to limit the amount of data retrieved, not to specify that data should be eager loaded.