A
DataSet
is superset of
DataTable
. One
Dataset
can have more than one
DataTable
. You need to find out which DataTable(in your SQL result set if you have more than one results of your query) you want to compare with the DataTable you have in question.
And then you can use Linq to find the differences by using
Except
. Check the link below it provides a good example on how you can do that:
Comparing DataSets using LINQ[
^]