Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Convert Dataset to IQueryable<T> or IEnumerable<T>

Since there is no Linq to DB2 yet (c'mon IBM!), and I want to deal with IQueryables or IEnumerables in my code, how would I convert a DataTable to an IQueryable? Or an IEnumerable?

I have an interface and a class that matches the columns in the datatable...

IQueryable<IMyData> GetAS400Data(..parameters..)
{
    DataSet d = GetData();
    ...
    //Some code to convert d to IQueryable<IMyData>
}

DataTable.Rows does not support .AsQueryable, since MSFT yanked it, so I'm not sure what to do here.

like image 534
jlembke Avatar asked Feb 02 '09 21:02

jlembke


2 Answers

table.AsEnumerable()...

table.AsEnumerable().AsQueryable()...

However, you'd need to write your own translation (Select) to your type; and the IQueryable<T> would still be using LINQ-to-Objects; the only purpose (in this scenario) of using IQueryable<T> over IEnumerable<T> would be to use expressions for some other reason - perhaps for the dynamic LINQ library.

like image 69
Marc Gravell Avatar answered Sep 19 '22 21:09

Marc Gravell


you can use something like this.

DataSet ds = GetData();
DataTable dt= ds.Tables[0];
var query =
    from row in dt.AsEnumerable() 
    select new IMyData()
    {
        property1= row[0],
        property2= row[1]
    };
like image 32
Rami Sarieddine Avatar answered Sep 19 '22 21:09

Rami Sarieddine