Eagerly loading entities in Linq2Sql

Answer 1

all Customer's orders for which an English product translation exists

dataLoadOptions.AssociateWith<TCustomer>(c => c.Orders
  .Where(o => o.Products
      .SelectMany(p => p.ProductTranslations)
      .Any(pt => pt.Language == "En")
  )
);