Multiple conditions in linq lambda query

Question

Three conditions in linq where clause using lambda expressions

List<Tbl_MVPConsultant> _objConsultants = _datalayer.Get_MVP_Consultants();

 _objConsultants = _objConsultants.Where(p => p.Country.ToLower().Contains(SearchTextbox.ToLower()) ||
                    p.State.ToLower().Contains(SearchTextbox.ToLower()) ||
                    p.City.ToLower().Contains(SearchTextbox.ToLower())).ToList();

I'm trying to achieve a filter operation three times using the above query .. but i'm getting an error stating object reference not set to an instance of an object ..

Looking for a quick solution.Appreciate early efforts. Thank you

are you sure _objConsultants has data? check out this link: stackoverflow.com/questions/2281083/… — sjramsay
– sjramsay, Commented Oct 14, 2014 at 13:59
Yeah _objConsultants has data and the _objConsultants = _objConsultants.Where(p => p.Country.ToLower().Contains(SearchTextbox.ToLower()) || p.State.ToLower().Contains(SearchTextbox.ToLower())).ToList(); I was able to fetch the results based on the two conditions but fails for the three condition statement.. @Niranjan Kala — Dathatreya
– Dathatreya, Commented Oct 15, 2014 at 7:04
Yes you and Jon were both right about it. There are some null values in the table. How to apply the checking of nulls at the start of lambda, @Niranjan Kala ? I'm very new to Linq ... — Dathatreya
– Dathatreya, Commented Oct 15, 2014 at 14:19

Jon · Accepted Answer · 2014-10-14 16:24:41Z

1

You won't be able to call p.Country.ToLower if p.Country is null. Put p.Country != null && p.State != null && p.City != null && at the start of the lambda.

answered Oct 14, 2014 at 16:24

Jon

1261 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dathatreya Over a year ago

You're right about it, there are some null values How to apply the checking of nulls at the start of lambda. can you re write my query @jon

Collectives™ on Stack Overflow

Multiple conditions in linq lambda query

Three conditions in linq where clause using lambda expressions

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Three conditions in linq where clause using lambda expressions

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related