- Oubliette -

 //Si usamos Linq2SQL usar   
 NorthwindDataContext nc = new NorthwindDataContext();   
 NorthwindEntities ne = new NorthwindEntities();   
 var suppliers = from s in ne.Suppliers   
       where (s.CompanyName.StartsWith("E"))   
       select s.SupplierID;   
 int[] supplierIDs = suppliers.ToArray();   
 var products = from p in ne.Products   
       where (supplierIDs.Contains((int)p.SupplierID))   
       select p;