Clever Geek Handbook

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


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


source






More articles:


All Articles