I have two tables in a typed DataSet and I want to compare one column in each table to see if TableA has values that are not in TableB.
This is assuming that both AField and BField are the same type.
IEnumerable<string> valuesInA = typedDataSet.TableA.AsEnumerable().Select(row => row.AField);
IEnumerable<string> valuesInB = typedDataSet.TableB.AsEnumerable().Select(row => row.BField);
foreach (var notInB in valuesInA.Except(valuesInB))
Debug.WriteLine(string.Format("Value not in TableB.BField: {0}", notInB));
This is assuming that both AField and BField are the same type.
Comments