Breaking News: Grepper is joining You.com. Read the official announcement!

linq conditionnally add where clause

Healthy Hare answered on September 21, 2021 Popularity 5/10 Helpfulness 2/10

answer linq conditionnally add where clause

linq conditionnally add where clause

Comment

var query = from u in DataContext.Users
   where u.Division == strUserDiv 
   && u.Age > 18
   && u.Height > strHeightinFeet
   select u;

if (useAge)
   query = query.Where(u => u.Age > age);

if (useHeight)
   query = query.Where(u => u.Height > strHeightinFeet);

// Build the results at the end
var results = query.Select(u => new DTO_UserMaster
   {
     Prop1 = u.Name,
   }).ToList();

Popularity 5/10 Helpfulness 2/10 Language csharp

Source: stackoverflow.com

Tags: add c# linq where-clause

Link to this answer
Share Copy Link