linq, selecting columns as IEnumerable<DataRow>
- by joe
how can i do in linq:
IEnumerable<DataRow> query =
from rec in dt.AsEnumerable()
where rec.Field<decimal>("column2") == 1 && foo(rec.Field<decimal>("column1"))
select new {
column1 = rec.Field<decimal>("column1"),
column2 = rec.Field<decimal>("column2"),
column3 = rec.Field<decimal>("column3")} ;
this does not work. Im trying to select some columns as new datatable then join it later with some other datatable.