
Untitled
By: a guest on
May 9th, 2012 | syntax:
None | size: 1.23 KB | hits: 16 | expires: Never
Multiple WHERE Clauses with LINQ extension methods
DateTime today = DateTime.UtcNow;
var results = from order in context.Orders
where ((order.OrderDate <= today) && (today <= order.OrderDate))
select order;
if (useAdditionalClauses)
{
results = results.Where(o => o.OrderStatus == OrderStatus.Open) // Now I'm stuck.
}
results = results.Where(o => (o.OrderStatus == OrderStatus.Open) &&
(o.CustomerID == customerID));
results = results.Where(o => (o.OrderStatus == OrderStatus.Open))
.Where(o => (o.CustomerID == customerID));
results = results.Where (o => o.OrderStatus == OrderStatus.Open);
results = results.Where (o => o.InvoicePaid);
if (useAdditionalClauses)
{
results = results.Where(o => o.OrderStatus == OrderStatus.Open && o.CustomerID == customerID) // Now I'm stuck.
}
if (useAdditionalClauses)
{
results =
results.Where(o => o.OrderStatus == OrderStatus.Open &&
o.CustomerID == customerID)
}
if (useAdditionalClauses)
{
results = results.Where(o => o.OrderStatus == OrderStatus.Open).
Where(o => o.CustomerID == customerID);
}
results = context.Orders.Where(o => o.OrderDate <= today && today <= o.OrderDate)