Question
Is there a plan to make Dapper.net compatible with IQueryable interfaces? If not, what's the workaround to use Dapper with "Expression Trees" filters?
Accepted Answer
No, there are no plans to do this. It is far far outside what dapper tries to do. So far that I would say it is antithetical. Dapper core tries to be the friend to those who love their SQL.
Popular Answer
You can get IQueryable from IEnumerable using the built-in extension method AsQueryable in System.Linq namespace
public IQueryable<Order> GetOrdersAsQuerable()
{
IEnumerable<Order> qry= GetOrders(); //using Query<T>
//use the built-in extension method AsQueryable in System.Linq namespace
return qry.AsQueryable();
}
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why