How do I pass a parameter from the select list into a function for joining a linq query?
- by Ryan ONeill
I have a query that can be summarised in SQL as follows;
Select
S.StockCode
From
StockToCheck As S
Inner Join
GetPOSStock(S.StockCode) As C
On S.StockCode = C.StockCode;
I'm trying to do the same in Linq but it seems I cannot pass a parameter to the function I am joining on as it has not been parsed by Linq.
I imagine it would look…