Building where clause dynamically in Linq

Question

Hi How to build the where clause in LINQ according to the supplied valuesSay for example user can search only by Name or by Name and Mobile No or by Name or City and so on ie as per combination of filedsThanks

dharmendr · Accepted Answer

Hi  AjayPYou should apply where condition like belowvar strQuery  from customer in cdeCustomers                select customerif stringIsNullOrEmptystrMobNo    strQuery  strQueryWherex gt xCustMobNo  strMobNoif stringIsNullOrEmptystrName    strQuery  strQueryWherex gt xCustName  strNameif stringIsNullOrEmptystrCity    strQuery  strQueryWherex gt xCustCity  strCity

Building where clause dynamically in Linq

LINQ to SQL CRUD: Select Insert Edit Update and Delete using LINQ to SQL in ASP.Net

Company

Explore

Follow us

Contact Us