Linq dynamically Add Where conditions
Cenk
956
Reputation points
Hi,
I am getting values from various form inputs and trying to dynamically construct the where clause. I couldn't find a way to, unfortunately. Hope you can help.
Here is
public async Task<IEnumerable<Order>> GetOrdersForExport(int vendorId,string status, DateTime? startDateTime, DateTime? endDateTime)
{
var result = from order in _db.Orders
from orderDetail in _db.OrdersDetail on order.Id equals orderdetail.OrderId
from vendor in _db.Vendors on orderdetail.VendorId equals vendor.Id
select new {order, orderdetail, vendor} ;
if (vendorId != null)
{
}
return await result;
}
Here is the relations