Using SelectMany Extension Method to Select Multiple Columns from DataRow List with result as subset of datarow list

Question

I have a datatable containing 10 columns. I want to select only two columns of them.

I am not able to do it using SelectMany Extension Method.

I know how to get it from Linq To DataSet but trying using this extension method.

Answer 1

SelectMany is the wrong method to try to use. You simply need to use Select and create a new anonymous object:

dataTable.AsEnumerable().Select(r => new { r.Column1, r.Column7 });

SelectMany is used to flatten nested collections.

Answer 2

var s = table.Rows.Cast().Select(....);

Answer 3

The SelectMany method is used for flattening a sequence of sequences, not for just selecting a subset of the available columns. Use the Select method instead:

var query = yourDataTable.AsEnumerable()
                         .Select(r => new { Column3 = r[3], Column6 = r[6] });