That seems to work the query I am having issues with is a little more complex
var leads = from folder in _Session.Query<LoanFolder>() from loan in folder.LoanFiles from brw in loan.Application.Borrowers select brw.ContactDetails; with this query I am getting a the following error: --------------------------------------------------------------------- Specified method is not supported. System.NotSupportedException Void VisitAdditionalFromClause(Remotion.Data.Linq.Clauses.AdditionalFromClause, Remotion.Data.Linq.QueryModel, Int32) Void Accept(Remotion.Data.Linq.IQueryModelVisitor, Remotion.Data.Linq.QueryModel, Int32) Void VisitBodyClauses(Remotion.Data.Linq.Collections.ObservableCollection`1[Remotion.Data.Linq.Clauses.IBodyClause], Remotion.Data.Linq.QueryModel) Void VisitQueryModel(Remotion.Data.Linq.QueryModel) Void Visit() NHibernate.Linq.ExpressionToHqlTranslationResults GenerateHqlQuery(Remotion.Data.Linq.QueryModel, NHibernate.Linq.Visitors.VisitorParameters, Boolean) NHibernate.Hql.Ast.ANTLR.Tree.IASTNode Translate(NHibernate.Engine.ISessionFactoryImplementor) NHibernate.Hql.IQueryTranslator[] CreateQueryTranslators(System.String, NHibernate.IQueryExpression, System.String, Boolean, System.Collections.Generic.IDictionary`2[System.String,NHibernate.IFilter], NHibernate.Engine.ISessionFactoryImplementor) NHibernate.Hql.IQueryTranslator[] CreateTranslators(System.String, NHibernate.IQueryExpression, System.String, Boolean, System.Collections.Generic.IDictionary`2[System.String,NHibernate.IFilter], NHibernate.Engine.ISessionFactoryImplementor) Void .ctor(System.String, NHibernate.IQueryExpression, System.String, Boolean, System.Collections.Generic.IDictionary`2[System.String,NHibernate.IFilter], NHibernate.Engine.ISessionFactoryImplementor) Void .ctor(System.String, NHibernate.IQueryExpression, Boolean, System.Collections.Generic.IDictionary`2[System.String,NHibernate.IFilter], NHibernate.Engine.ISessionFactoryImplementor) NHibernate.Engine.Query.IQueryExpressionPlan GetHQLQueryPlan(NHibernate.IQueryExpression, Boolean, System.Collections.Generic.IDictionary`2[System.String,NHibernate.IFilter]) NHibernate.Engine.Query.IQueryExpressionPlan GetHQLQueryPlan(NHibernate.IQueryExpression, Boolean) NHibernate.IQuery CreateQuery(NHibernate.IQueryExpression) System.Object Execute(System.Linq.Expressions.Expression) TResult Execute[TResult](System.Linq.Expressions.Expression) System.Collections.Generic.IEnumerator`1[T] GetEnumerator() Void ForEach[T](System.Collections.Generic.IEnumerable`1[T], System.Action`1[T]) -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
