我有两个课程(请求和请求细节).我需要一个
Linq到NHibernatequery之间的两个类之间加入.
var q = SessionInstance.Query<Request>()
.Where(x => x.State == "Init");
var q2 = SessionInstance.Query<RequestDetail>();
q2 = q2.Where(xx => xx.Purpose.Contains("Purpose Sample")); // This line has a error When execution `q.ToList()`
q = q.Join(q2,request => request.Id,detail => detail.Id,(request,detail) => request);
return q.ToList();
当我向q2添加Where条件时,Result有一个运行时错误.异常消息是：不支持指定的方法.
堆栈跟踪 ：
at NHibernate.Hql.Ast.ANTLR.PolymorphicQuerySourceDetector.GetClassName(IASTNode querySource) at NHibernate.Hql.Ast.ANTLR.PolymorphicQuerySourceDetector.Process(IASTNode tree) at NHibernate.Hql.Ast.ANTLR.AstPolymorphicProcessor.Process() at NHibernate.Hql.Ast.ANTLR.ASTQueryTranslatorFactory.CreateQueryTranslators(IASTNode ast,String queryIdentifier,String collectionRole,Boolean shallow,IDictionary`2 filters,ISessionFactoryImplementor factory) at NHibernate.Hql.Ast.ANTLR.ASTQueryTranslatorFactory.CreateQueryTranslators(String queryIdentifier,IQueryExpression queryExpression,ISessionFactoryImplementor factory) at NHibernate.Engine.Query.QueryPlanCache.GetHQLQueryPlan(IQueryExpression queryExpression,IDictionary`2 enabledFilters) at NHibernate.Impl.AbstractSessionImpl.GetHQLQueryPlan(IQueryExpression queryExpression,Boolean shallow) at NHibernate.Impl.AbstractSessionImpl.CreateQuery(IQueryExpression queryExpression) at NHibernate.Linq.NhQueryProvider.PrepareQuery(Expression expression,IQuery& query,NhLinqExpression& nhQuery) at NHibernate.Linq.NhQueryProvider.Execute[TResult](Expression expression) at Remotion.Data.Linq.QueryableBase`1.GetEnumerator() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
为什么？
解决方法
这可能是一个bug.
以下是您的问题的解决方法：
var q = (from request in session.Query<Request>()
join detail in session.Query<RequestDetail>() on request.Id equals detail.Id
where request.State == "Init" && detail.Purpose.Contains("Purpose Sample")
select request).ToList();
