LINQ to Object to DataSet

Question

Can I do a LINQ Join from an List to a DataSet? Are there any caveats to doing this?

Answer 1

There are obvious performance problems ahead, depending on the size of each side of the join, so the real caveat is scale.

You won't have to do any converting, you can select rows out of the dataset/table as you would normally with LINQ and just include an "on" clause to tell it how to compare a row to your List<T>.