Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Converting Datatable to ienumerable<anonymous>?

is it possible to convert data table to ienumerable without know its class name.

my requirement is to convert table

First | Last
--------------
john  | mcgill
clara | linda   

to

{{First:john,Last:mcgill},{First:clara ,Last:linda}}

Ienumerable collection

i dont want to use dynamic object because dynamic object supports only frame work 4.

thanks

like image 315
YogeshWaran Avatar asked Oct 15 '25 07:10

YogeshWaran


1 Answers

var results = from row in dataTable.AsEnumerable()
              select new {
                  First = row.Field<string>("First"),
                  Last = row.Field<string>("Second")
              };

You'll need System.Data.DataSetExtensions.

like image 102
jason Avatar answered Oct 18 '25 06:10

jason