Not equal in LINQ?

Question

Table:

TableA

SerialNUmber   Status
001              OK
002              N/A

TableB

SerialNumber    Status
001              OK
003              N/A

  var ret = (from p in TableA.AsEnumerable()
      join q in TableB.AsEnumerable()
       on p.Field<string>("SerialNumber") equals q.Field<string>("SerialNumber") 
          select new
            {
              SerialNUmber = q["SerialNumber"],
              UnitStatus = "HOT",
              PartNumber = q["PartNumber"]
            }).ToList();

ret

SerialNumber    Status
001              OK

This query returns the matching data in my list. Now I need to do another way to show TV shows that are not equal to each other.

Ret

SerialNumber    Status
002              N/A
003              N/A

Thank Advance

Answer 1

You can implement EqualityComparer as follows:

public class SerialNumberComparer : IEqualityComparer<DataRow>
{
  public bool Equals(Datarow d1, DataRow d2)
  {
    return d1.Field<string>("SerialNumber") == d2.Field<string>("SerialNumber");
  }
}

And then use the LINQ extension method Except:

var aEnum = TableA.AsEnumerable();
var bEnum = TableB.AsEnumerable();
var comp = new SerialNumberComparer();
var ret = from q in bEnum.Except(aEnum, comp).Concat(aEnum.Except(bEnum, comp))
select new
         {
           SerialNumber = q["SerialNumber"],
           UnitStatus = "HOT",
           PartNumber = q["PartNumber"]
         };