Convert Dataset to IQueryable or IEnumerable

Table.AsEnumerable()... table.AsEnumerable().AsQueryable() However, you'd need to write your own translation ( Select ) to your type; and the IQueryable.

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

– MattSlay Mar 30 '09 at 17:03 The IQueryable is essentially a view over the data. The original DataTable still remains. To create a DataTable, perhaps see this: stackoverflow.

Com/questions/545328/… – Marc Gravell? Mar 30 '09 at 19:15.

Take a look here it seems that a provider with entity framework for DB2 exists.

Unfortunately, due to a bad experience last year, EF has been ruled out for me. That's unfortunate, since EF is MSFT's future... – jlembke Feb 3 '09 at 16:56.