How can I get an IQueryable for a table that is not mapped? RRS feed

  • Question

  • The starting point of a linq to sql is an IQueryable<T> or IQueryable but the only way to generate that is using DataContext.GetTable<T> or DataContext.GetTable(Type type).

    Well, what if you don't have a type mapped to a table?  In my app, a user will select from a list of available tables and be able to browse the data in the selected table.  I also need to perform sorting and filtering.  The Dynamic Linq code sample came in very handy for this.

    But even then I need to have a mapped Type.

    Do I need to create a custom IQueryable provider for it?

    Friday, April 30, 2010 11:52 AM