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?


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)



All Articles