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);