Comiple query that uses "Contains" - error: parameters cannot be sequences
Posted: Tue 19 Feb 2013 16:18
I am trying to compile a query that uses Contains
But when I try and use the compiled query I always get the error: parameters cannot be sequences
Code: Select all
_getTradeDataQuery = CompiledQuery.Compile<TSDataContext, TradeDataParams, IEnumerable<VwAvailProjTradeDataTrade>>(
(context, dataKey) =>
from trade in context.VwAvailProjTradeDataTrades
where trade.CurrencyCode == dataKey.Currency
&& trade.PeriodType == dataKey.PeriodType
&& trade.NomenCode == dataKey.Nomenclature
&& trade.DigitLevel == dataKey.DigitLevel
&& dataKey.FlowTypes.Contains(trade.FlowType.Value)
&& dataKey.Reporters.Contains(trade.Reporter.Value)
&& dataKey.Partners.Contains(trade.Partner.Value)
&& dataKey.Years.Contains(trade.Year.Value)
select trade);