How to apply Where, Select, OrderBy, etc. To the results of a stored procedure in LinqPad?
When I tried to filter or project the result from a stored procedure, I might make the following error in LinqPad.
'LINQPad.ReturnDataSet' does not contain a definition for 'Where' and there is no extension method "Where" taking the first argument of type "LINQPad.ReturnDataSet" can be found
Is there a workaround?
+3
darcyq
source
to share
1 answer
Calling AsDynamic()
the resulting stored procedure will allow you to apply Linq operations, eg.spOrders.AsDynamic().Where(o => o.Id > 100)
+7
darcyq
source
to share