How to use Linq on a Dataset

Here’s an example of using Linq on a dataset table.

ICollection<MyDataSet. MyTableRow > rowsToDoSomethingWith = new List< MyDataSet.MyTableRow>(
from x in myDataSet.MyTable.AsEnumerable()
where x.Field<String>("Column1") == "Y"
select x);