var x = (from q in from ps in session.Query<GetProductSold>() join pl in session.Query<ProductLanguage>() on ps.ProductId equals pl.ProductLanguageCompositeKey.ProductId select new { ps, pl } where q.pl.ProductLanguageCompositeKey.LanguageCode == languageCode select q).Cacheable();
We can convert that to following, however NHibernate doesn't support this yet:
var x = (from q in from ps in session.Query<GetProductSold>() join pl in session.Query<ProductLanguage>().Where(plc => plc.ProductLanguageCompositeKey.LanguageCode == languageCode) on ps.ProductId equals pl.ProductLanguageCompositeKey.ProductId select new { ps, pl } select q).Cacheable();
We have to do it this way:
var x = (from q in from ps in session.Query<GetProductSold>() join pl in session.Query<ProductLanguage>() on new { ps.ProductId, LanguageCode = languageCode } equals new { pl.ProductLanguageCompositeKey.ProductId, pl.ProductLanguageCompositeKey.LanguageCode } select new { ps, pl } select q).Cacheable();
No comments:
Post a Comment