There are too many top Google search results giving the impression that it is impossible to compare 2 DataRows for its value contents and the programmer needs to iterate through everything himself.
Such is no longer true in .NET 3.5 but the blogosphere doesn’t seem to have caught on yet.
It is possible, given 2 DataTables or any other enumerable object types, to compare its contents using LINQ in just one line of code.
I will give an example in VB where I’d want to compare all column properties (description, data type, field length, etc) of all tables in 2 supposedly identical SQL databases. Read More…