Linq select in query in c#

Question

I have two lists containing data.

List<changeLogUsers> users;

UserID


List<changeLogQualifications> userQualifications;

UserID
QualificationID

I want to select only those userQualifications for which UserID is available in users list.

Can anyone help?

This thread may be helpful. http://stackoverflow.com/questions/7187996/intersect-two-list-in-c-sharp — Krishna Sarma, Sep 10 '13 at 07:39

score 1 · Answer 1 · answered Sep 10 '13 at 07:32

1

var result = userQualifications.Where(u => users.Any(x => x.UserID == u.UserID));

answered Sep 10 '13 at 07:32

cuongle

score 0 · Answer 2 · answered Sep 10 '13 at 07:32

0

Try this

List<changeLogQualifications> userQualifications.Select(p=>p.UserID!=null);

answered Sep 10 '13 at 07:32

Amit

score 0 · Answer 3 · answered Sep 10 '13 at 07:38

0

Or alternatively:

var results = from uq in userQualifications
              join u in users on uq.UserID equals u.UserID
              select uq;

answered Sep 10 '13 at 07:38

James S

3 Answers3