LINQ query to query a list with array members

Question

I am trying to query a list using LINQ.

The query statement contains entries which should match items from an array.

In other words get entries from SourceList which match any one of the items from the items array. Example:

private List<string> GetSearchResult(List<string> SourceList,
    string name, string[] items)
{
     IEnumerable<string> QueryList = SourceList.Where
         (entry => enrty.name == name && entry.id == <any item from items>)
}

I thought of building a query string looping though the items array. I wanted to know if there is an efficient way of doing this.

sorry my mistake result is IEnumerable not List

fireBand
– fireBand

2010-11-23 21:19:29 +00:00
Commented Nov 23, 2010 at 21:19 — fireBand
– fireBand, Commented Nov 23, 2010 at 21:19

Robert Harvey · Accepted Answer · 2010-11-23 21:08:31Z

4

private List<string> GetSearchResult(List<string> SourceList,
    string name, string[] items)
{
     return SourceList.Where(entry => entry.name == name 
         && items.Contains(entry.id))
}

edited Nov 23, 2010 at 21:08

Robert Harvey

182k48 gold badges349 silver badges516 bronze badges

answered Nov 23, 2010 at 21:06

as-cii

13.1k5 gold badges44 silver badges43 bronze badges

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

1 Comment

Khalid Abuhakmeh Over a year ago

this will work, but if SourceList becomes a List<MyObject> you should think about implementing your own comparer. This will give you a way to customize your compare, for example X.Id == Y.Id.

Adam Driscoll · Accepted Answer · 2010-11-23 21:06:22Z

2

What about:

private List<string> GetSearchResult(List<string> SourceList,string name, string[] items)
{
     List<string> QueryList = SourceList.Where
                     (entry => enrty.name == name && items.Any(m => m == entry.id.ToString()))
}

answered Nov 23, 2010 at 21:06

Adam Driscoll

9,5139 gold badges66 silver badges108 bronze badges

Comments

Mike Caron · Accepted Answer · 2010-11-23 21:06:45Z

1

private List<string> GetSearchResult(List<string> SourceList,string name, string[] items)
{
     return SourceList.Where(entry => entry.name == name && items.Contains(entry.id)).ToList();
}

That should do it.

answered Nov 23, 2010 at 21:06

Mike Caron

14.6k4 gold badges53 silver badges77 bronze badges

Collectives™ on Stack Overflow

LINQ query to query a list with array members

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related