CODEWITHSUNDEEP
linqentity-framework
chadis
chadis

Reputation: 11

How to compare column in 2 list with linq

How to compare and take only products in list product where p.street==a.street List products {p1, p2, p3} list address {a1, a2, a3}

Example:

  1. ListProduct= {P1, Paris} {P2, London} {P3 New York} {P4 Bagdad} {P5 Rome}
  2. Liste Adresse= {A1, Paris} {A2, Rome}

3.ListeProductResult= {P1, Paris} {P5 Rome}

Both solutions work very well Thanks I want to add a second list for comparison CategorieProduct={c1,c2}

It works but what is the best solution

 var result = from product in ListProduct 
         join address in ListAddresse on product.Street equals address.Street 
         join Categories in ListCategories on product.CategorieNom equals Categorie.CategorieNom  select product;

Upvotes: 1

Views: 4875

Answers (2)

Stuart
Stuart

Reputation: 66882

The best way of doing this is to use a join - this will match the properties across the two different entities

var result = from product in ListProduct
             join address in ListAddresse on product.Street equals address.Street
             select product;

If this gives you multiple matches (e.g. if you had multiple matching addresses for a single product) then you could then additionally apply Distinct() to the output of this query.

For more examples of Linq in action, please see the excellent 101 linq examples on MSDN - including a section on joins - http://msdn.microsoft.com/en-us/vcsharp/ee908647#crossjoin

Upvotes: 1

Mahesh Velaga
Mahesh Velaga

Reputation: 21991

It can be done using those lists as follows: (assuming Street is the property that we are comparing)

var result = productsList
         .Where(product => addressList
                         .Any(address => address.Street == product.Street));

Upvotes: 0

Related Questions