Linq - Compare two datatables

See more:

VB

LINQ

I have two datatables filled from an earlier process.

Both data tables are of the same structure and are a effectively a list of transactions.

DataTable1
DataTable2

I want to check what transactions exist in DataTable1 that do not exist in DataTable2 and return the results in a new DataTable based on column "TransactionRef"

I then want to check what transactions exist in DataTable2 that do not exist in DataTable1 and return the results in a new DataTable.

Is anyone able to help?

Thanks

BM