I would not expect you to get different exceptions depending on dialect for this, as long as the linq query is exactly the same.
Anyway, it sounds like a known limitation: https://nhibernate.jira.com/browse/NH-2566 /Oskar 2012/11/14 Rodrigo Sendin <[email protected]> > Correcting my original post, the problem occurs with SQLServer too. > Here the exception I got: > > em > NHibernate.Linq.GroupBy.AggregatingGroupByRewriter.FlattenSubQuery(SubQueryExpression > subQueryExpression, QueryModel queryModel) na > p:\nhibernate-core\src\NHibernate\Linq\GroupBy\AggregatingGroupByRewriter.cs:linha > 50 > em > NHibernate.Linq.GroupBy.AggregatingGroupByRewriter.ReWrite(QueryModel > queryModel) na > p:\nhibernate-core\src\NHibernate\Linq\GroupBy\AggregatingGroupByRewriter.cs:linha > 41 > em > NHibernate.Linq.Visitors.QueryModelVisitor.GenerateHqlQuery(QueryModel > queryModel, VisitorParameters parameters, Boolean root) na > p:\nhibernate-core\src\NHibernate\Linq\Visitors\QueryModelVisitor.cs:linha > 32 > em > NHibernate.Linq.NhLinqExpression.Translate(ISessionFactoryImplementor > sessionFactory) na > p:\nhibernate-core\src\NHibernate\Linq\NhLinqExpression.cs:linha 62 > em > NHibernate.Hql.Ast.ANTLR.ASTQueryTranslatorFactory.CreateQueryTranslators(String > queryIdentifier, IQueryExpression queryExpression, String collectionRole, > Boolean shallow, IDictionary`2 filters, ISessionFactoryImplementor factory) > na > p:\nhibernate-core\src\NHibernate\Hql\Ast\ANTLR\ASTQueryTranslatorFactory.cs:linha > 27 > em > NHibernate.Engine.Query.HQLExpressionQueryPlan.CreateTranslators(String > expressionStr, IQueryExpression queryExpression, String collectionRole, > Boolean shallow, IDictionary`2 enabledFilters, ISessionFactoryImplementor > factory) na > p:\nhibernate-core\src\NHibernate\Engine\Query\HQLExpressionQueryPlan.cs:linha > 34 > em NHibernate.Engine.Query.HQLExpressionQueryPlan..ctor(String > expressionStr, IQueryExpression queryExpression, String collectionRole, > Boolean shallow, IDictionary`2 enabledFilters, ISessionFactoryImplementor > factory) na > p:\nhibernate-core\src\NHibernate\Engine\Query\HQLExpressionQueryPlan.cs:linha > 23 > em NHibernate.Engine.Query.HQLExpressionQueryPlan..ctor(String > expressionStr, IQueryExpression queryExpression, Boolean shallow, > IDictionary`2 enabledFilters, ISessionFactoryImplementor factory) na > p:\nhibernate-core\src\NHibernate\Engine\Query\HQLExpressionQueryPlan.cs:linha > 17 > em > NHibernate.Engine.Query.QueryPlanCache.GetHQLQueryPlan(IQueryExpression > queryExpression, Boolean shallow, IDictionary`2 enabledFilters) na > p:\nhibernate-core\src\NHibernate\Engine\Query\QueryPlanCache.cs:linha 88 > em NHibernate.Impl.AbstractSessionImpl.GetHQLQueryPlan(IQueryExpression > queryExpression, Boolean shallow) na > p:\nhibernate-core\src\NHibernate\Impl\AbstractSessionImpl.cs:linha 312 > em NHibernate.Impl.AbstractSessionImpl.CreateQuery(IQueryExpression > queryExpression) na > p:\nhibernate-core\src\NHibernate\Impl\AbstractSessionImpl.cs:linha 268 > em NHibernate.Linq.DefaultQueryProvider.PrepareQuery(Expression > expression, IQuery& query, NhLinqExpression& nhQuery) na > p:\nhibernate-core\src\NHibernate\Linq\DefaultQueryProvider.cs:linha 69 > em NHibernate.Linq.DefaultQueryProvider.Execute(Expression expression) > na p:\nhibernate-core\src\NHibernate\Linq\DefaultQueryProvider.cs:linha 33 > em NHibernate.Linq.DefaultQueryProvider.Execute[TResult](Expression > expression) na > p:\nhibernate-core\src\NHibernate\Linq\DefaultQueryProvider.cs:linha 40 > em Remotion.Linq.QueryableBase`1.GetEnumerator() na :linha 0 > em System.Linq.SystemCore_EnumerableDebugView`1.get_Items() > > Em quarta-feira, 14 de novembro de 2012 15h51min13s UTC-2, Rodrigo Sendin > escreveu: > >> Sorry. Here is the entire exception: >> >> System.NotSupportedException was unhandled by user code >> HResult=-2146233067 >> Message=Não há suporte para o método especificado. >> Source=NHibernate >> StackTrace: >> em >> NHibernate.Hql.Ast.ANTLR.**PolymorphicQuerySourceDetector**.GetClassName(IASTNode >> querySource) >> em >> NHibernate.Hql.Ast.ANTLR.**PolymorphicQuerySourceDetector**.Process(IASTNode >> tree) >> em NHibernate.Hql.Ast.ANTLR.**AstPolymorphicProcessor.**Process() >> em >> NHibernate.Hql.Ast.ANTLR.**AstPolymorphicProcessor.**Process(IASTNode >> ast, ISessionFactoryImplementor factory) >> em NHibernate.Hql.Ast.ANTLR.**ASTQueryTranslatorFactory.** >> CreateQueryTranslators(**IASTNode ast, String queryIdentifier, String >> collectionRole, Boolean shallow, IDictionary`2 filters, >> ISessionFactoryImplementor factory) >> em >> NHibernate.Hql.Ast.ANTLR.**ASTQueryTranslatorFactory.**CreateQueryTranslators(String >> queryIdentifier, IQueryExpression queryExpression, String collectionRole, >> Boolean shallow, IDictionary`2 filters, ISessionFactoryImplementor factory) >> em >> NHibernate.Engine.Query.**HQLExpressionQueryPlan.**CreateTranslators(String >> expressionStr, IQueryExpression queryExpression, String collectionRole, >> Boolean shallow, IDictionary`2 enabledFilters, ISessionFactoryImplementor >> factory) >> em NHibernate.Engine.Query.**HQLExpressionQueryPlan..ctor(**String >> expressionStr, IQueryExpression queryExpression, String collectionRole, >> Boolean shallow, IDictionary`2 enabledFilters, ISessionFactoryImplementor >> factory) >> em NHibernate.Engine.Query.**HQLExpressionQueryPlan..ctor(**String >> expressionStr, IQueryExpression queryExpression, Boolean shallow, >> IDictionary`2 enabledFilters, ISessionFactoryImplementor factory) >> em >> NHibernate.Engine.Query.**QueryPlanCache.**GetHQLQueryPlan(**IQueryExpression >> queryExpression, Boolean shallow, IDictionary`2 enabledFilters) >> em >> NHibernate.Impl.**AbstractSessionImpl.**GetHQLQueryPlan(**IQueryExpression >> queryExpression, Boolean shallow) >> em >> NHibernate.Impl.**AbstractSessionImpl.**CreateQuery(IQueryExpression >> queryExpression) >> em NHibernate.Linq.**DefaultQueryProvider.**PrepareQuery(Expression >> expression, IQuery& query, NhLinqExpression& nhQuery) >> em NHibernate.Linq.**DefaultQueryProvider.Execute(**Expression >> expression) >> em Remotion.Linq.QueryableBase`1.**System.Collections.** >> IEnumerable.GetEnumerator() >> em >> Kendo.Mvc.Extensions.**QueryableExtensions.Execute[**TModel,TResult](IQueryable >> source, Func`2 selector) >> em Kendo.Mvc.Extensions.**QueryableExtensions.** >> CreateDataSourceResult[TModel,**TResult](IQueryable queryable, >> DataSourceRequest request, ModelStateDictionary modelState, Func`2 selector) >> em >> Kendo.Mvc.Extensions.**QueryableExtensions.**ToDataSourceResult(IQueryable >> queryable, DataSourceRequest request, ModelStateDictionary modelState) >> em >> Kendo.Mvc.Extensions.**QueryableExtensions.**ToDataSourceResult(IQueryable >> enumerable, DataSourceRequest request) >> em Portal.Web.Controllers.**UnidadeFederativaController.** >> ConsultaDados(**DataSourceRequest request, String filtro) na >> c:\Fontes\Interfocus\Portal\**trunk\src\Portal\Portal.Web\**Controllers\* >> *UnidadeFederativaController.**cs:linha 21 >> em >> Portal.Web.Controllers.**CadastroController`3.Select(**DataSourceRequest >> request, String filtro) na c:\Fontes\Interfocus\Portal\** >> trunk\src\Portal\Portal.Web\**Controllers\**CadastroController.cs:linha >> 49 >> em lambda_method(Closure , ControllerBase , Object[] ) >> em System.Web.Mvc.**ActionMethodDispatcher.**Execute(ControllerBase >> controller, Object[] parameters) >> em >> System.Web.Mvc.**ReflectedActionDescriptor.**Execute(ControllerContext >> controllerContext, IDictionary`2 parameters) >> em System.Web.Mvc.**ControllerActionInvoker.**InvokeActionMethod(* >> *ControllerContext controllerContext, ActionDescriptor actionDescriptor, >> IDictionary`2 parameters) >> em System.Web.Mvc.**ControllerActionInvoker.<>c__** >> DisplayClass15.<**InvokeActionMethodWithFilters>**b__12() >> em System.Web.Mvc.**ControllerActionInvoker.** >> InvokeActionMethodFilter(**IActionFilter filter, ActionExecutingContext >> preContext, Func`1 continuation) >> InnerException: >> >> >> Em quarta-feira, 14 de novembro de 2012 15h02min04s UTC-2, Oskar Berggren >> escreveu: >>> >>> >>> >>> 2012/11/14 Rodrigo Sendin <[email protected]> >>> >>> any idea how I can solve this issue? >>>> >>>> >>> Please start by providing more complete exception info so that we can >>> have a chance to figure out exactly what isn't supported. >>> >>> >>> /Oskar >>> >>> -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/nhusers/-/pHpaC6flQrkJ. > > 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. > -- 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.
