December 2007
Intermediate to advanced
896 pages
19h 57m
English
You want to be able to get a dynamic subset of a query result.
Use the TakeWhile extension method to retrieve all results until the criteria is matched:
Northwind dataContext = new Northwind(Settings.Default.NorthwindConnectionString);
var query =
dataContext.Suppliers.GroupJoin(dataContext.Products,
s => s.SupplierID, p => p.SupplierID,
(s, products) => new
{
s.CompanyName,
s.ContactName,
s.Phone,
Products = products
}).OrderByDescending(supplierData => supplierData.Products.Count())
.TakeWhile(supplierData => supplierData.Products.Count() > 3);
Console.WriteLine("Suppliers that provide more than three products: {0}", query.
Count());
foreach (var supplierData in query)
{
Console.WriteLine(" Company Name : {0}",supplierData.CompanyName);
Console.WriteLine(" Contact Name : {0}", supplierData.ContactName);
Console.WriteLine(" Contact Phone : {0}", supplierData.Phone);
Console.WriteLine(" Products Supplied : {0}", supplierData.Products.Count());
foreach (var productData in supplierData.Products)
{
Console.WriteLine(" Product: " + productData.ProductName);
}
}You can also use the SkipWhile extension method to retrieve all results once the criteria are matched:
Northwind dataContext = new Northwind(Settings.Default.NorthwindConnectionString); var query = dataContext.Suppliers.GroupJoin(dataContext.Products, s => s.SupplierID, p => p.SupplierID, (s, products) => new { s.CompanyName, s.ContactName, s.Phone, Products = products ...Read now
Unlock full access