multiple conditions in where statement in linq

Question

A variable posted by user from ui:"_author".
it can be one name or comma seperated more names.. first one is ok but I need to deal with second scenario _author = "Erick";// thats ok

here is fine with single name,

if (!string.IsNullOrEmpty(_author))
      {
          allQueryable = allQueryable.Where(u => u.Authors.Contains(_author));
      }

_author = "Erick,Jennifer,Patrick,..";//hmmm

what I tried for this case:

     if (!string.IsNullOrEmpty(_author)) 
{ 
       if (_author.Contains(',')) 
        {
        allQueryable = allQueryable.Where(u =>u.Authors.Intersect(_author.Split(',').ToArray())); 
       } 
       else 
          allQueryable = allQueryable.Where(u => u.Authors.Contains(_author));

}

Entity defination:

public class Book : EntityBase
    {
        public string Title { get; set; }
        public string Publisher { get; set; }
        public string Description { get; set; }
        public string[] Authors { get; set; }
    }

I think you meant to write if(!string.IsNullOrEmpty(_author)). You've excluded the "!" at the start of your condition. — Jace
– Jace, Commented Jul 24, 2016 at 2:47
My question is how can achieve my goal the thing above not work guys.. — TyForHelpDude
– TyForHelpDude, Commented Jul 24, 2016 at 13:30

user3248578 · Accepted Answer · 2016-07-24 04:06:23Z

2

You do not need to have a special case for one entry and multiple entries separated by commas, and you don't need to handle the case where the user types nothing. Replace the two nested if statements with these two lines:

string[] authors = _author.Replace(" ","").Split(',');
allQueryable = allQueryable.Where(u => u.Authors.Intersect(authors).Count() > 0).ToList();

answered Jul 24, 2016 at 4:06

user3248578

9238 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

multiple conditions in where statement in linq

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related