shamim
shamim

Reputation: 6778

Way to select from multi list

I have two list.Want to compare them

foreach (SQLFrameWorkEntity item in oListParent)
{
   foreach (SQLFrameWorkEntity item2 in oList)
   {
      if (item.TableNumber == item2.ReferenceNumber 
          && item.TableNumber!=item2.TableNumber)
      {
           oListReferenceTable.Add(item2);
      }
   }
}

I try to achieve this result in linq,but bellow syntax does not give me required output.

var r = oListParent.Select(p => 
                      oList.Select(q => q.ReferenceNumber == p.TableNumber))
                   .ToList();

help me to correction the above linq syntax to achieve the required output If have query plz ask.Thanks in advance

Upvotes: 1

Views: 145

Answers (2)

yas4891
yas4891

Reputation: 4862

var result = from item in oListParent 
             join item2 in oList on item.TableNumber equals item2.ReferenceNumber
             where item.TableNumber != item2.TableNumber
             select item2;

Upvotes: 2

twoflower
twoflower

Reputation: 6830

var r = oList.Where(x => oListParent.Any(y => y.TableNumber == x.ReferenceNumber &&
                                              y.TableNumber != x.TableNumber))
             .ToList()

Upvotes: 3

Related Questions