You got me wrong:) I said "I wouldn't use DataTable's Select which is awful compared to Linq". You were using Linq because CopyToDataTable() is Linq. It didn't exist since 2003, did it? No, it came with Linq as part of DataSetExtensions.

In VS2005 (pre-LINQ), there was a ToTable that you could place at the end of a DataView (and the ability to add a Distinct boolean)., to take the results of an ADO.NET filter and redirect to a new datatable.

You're right, I used CopyToDataTable, which is part of LINQ. I could have used either one (CopyToDataTable or ToTable)