Linq Query to Compare with List of string values

Question

I need to compare and get the matching values from a string list with LINQ. Have a look at my code.

Code

Split = Id.Split(',');
List<string> uids = new List<string>(Split);
var model = (from xx in Db.ItemWeedLogs
                where xx.ItemNo == uids   
                // I need to pass a string list to extract the matching record.
                select xx).ToList();

omg so late :/ this people so fast.

Mert
– Mert

2012-12-11 13:18:31 +00:00
Commented Dec 11, 2012 at 13:18 — Mert
– Mert, Commented Dec 11, 2012 at 13:18

Wahid Bitar · Accepted Answer · 2012-12-11 13:14:15Z

7

Try this :

var model = (from xx in Db.ItemWeedLogs
                     where uids.Contains(xx.ItemNo)
                     select xx).ToList();

answered Dec 11, 2012 at 13:14

Wahid Bitar

14.1k13 gold badges83 silver badges109 bronze badges

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

Comments

The_Cthulhu_Kid · Accepted Answer · 2012-12-11 13:14:38Z

2

Try:

where uid.contains(xx.ItemNo)

answered Dec 11, 2012 at 13:14

The_Cthulhu_Kid

1,8691 gold badge31 silver badges44 bronze badges

1 Comment

The_Cthulhu_Kid Over a year ago

@Dheyv You are more than welcome. You should accept Wahid's answer (he was first and clearer ;)

Hamlet Hakobyan · Accepted Answer · 2012-12-11 13:27:21Z

2

I think this is much more faster and clear.

var model = Db.ItemWeedLogs
              .Join(Id.Split(','), di => di.ItemNo, si => si, (d, s) => new {d})
              .ToList();

answered Dec 11, 2012 at 13:27

Hamlet Hakobyan

33.5k6 gold badges55 silver badges70 bronze badges

1 Comment

jbl Over a year ago

+1 , depending on the relative sizes of the collections, building up a dictionnary might be a good option too

Collectives™ on Stack Overflow

Linq Query to Compare with List of string values

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related