Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
In my code i have
Country.FirstOrDefault( x => x.TwoLetterISORegionName == "AU" );
AU is country code for australia. Australia is in my list of countries and it has the code of AU however this throws an exception
NHibernate.QueryException: could not resolve property: TwoLetterISORegionName of: UCommerce.EntitiesV2.Country [.FirstOrDefault[UCommerce.EntitiesV2.Country](.Where[UCommerce.EntitiesV2.Country](.Select[UCommerce.EntitiesV2.Country,UCommerce.EntitiesV2.Country](NHibernate.Linq.NhQueryable`1[UCommerce.EntitiesV2.Country], Quote((entity, ) => (entity)), ), Quote((x, ) => (String.op_Equality(x.TwoLetterISORegionName, p1))), ), )]
[QueryException: could not resolve property: TwoLetterISORegionName of: UCommerce.EntitiesV2.Country [.FirstOrDefault[UCommerce.EntitiesV2.Country](.Where[UCommerce.EntitiesV2.Country](.Select[UCommerce.EntitiesV2.Country,UCommerce.EntitiesV2.Country](NHibernate.Linq.NhQueryable`1[UCommerce.EntitiesV2.Country], Quote((entity, ) => (entity)), ), Quote((x, ) => (String.op_Equality(x.TwoLetterISORegionName, p1))), ), )]] NHibernate.Persister.Entity.AbstractPropertyMapping.ToType(String propertyName) +62 NHibernate.Persister.Entity.AbstractEntityPersister.ToType(String propertyName) +12 NHibernate.Hql.Ast.ANTLR.Tree.FromElementType.GetPropertyType(String propertyName, String propertyPath) +95 NHibernate.Hql.Ast.ANTLR.Tree.DotNode.GetDataType() +75 NHibernate.Hql.Ast.ANTLR.Tree.DotNode.PrepareLhs() +32 NHibernate.Hql.Ast.ANTLR.Tree.DotNode.Resolve(Boolean generateJoin, Boolean implicitJoin, String classAlias, IASTNode parent) +30 NHibernate.Hql.Ast.ANTLR.Tree.FromReferenceNode.Resolve(Boolean generateJoin, Boolean implicitJoin) +25 NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.Resolve(IASTNode node) +54 NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.expr() +528 NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.exprOrSubquery() +474 NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.comparisonExpr() +1259 NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.logicalExpr() +2081 NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.whereClause() +341 NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.unionedQuery() +1497 NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.query() +264 NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.selectStatement() +140 NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.statement() +302 NHibernate.Hql.Ast.ANTLR.HqlSqlTranslator.Translate() +193 NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.DoCompile(IDictionary`2 replacements, Boolean shallow, String collectionRole) +407 NHibernate.Hql.Ast.ANTLR.ASTQueryTranslatorFactory.CreateQueryTranslators(IASTNode ast, String queryIdentifier, String collectionRole, Boolean shallow, IDictionary`2 filters, ISessionFactoryImplementor factory) +200 NHibernate.Hql.Ast.ANTLR.ASTQueryTranslatorFactory.CreateQueryTranslators(String queryIdentifier, IQueryExpression queryExpression, String collectionRole, Boolean shallow, IDictionary`2 filters, ISessionFactoryImplementor factory) +42 NHibernate.Engine.Query.QueryPlanCache.GetHQLQueryPlan(IQueryExpression queryExpression, Boolean shallow, IDictionary`2 enabledFilters) +198 NHibernate.Impl.AbstractSessionImpl.GetHQLQueryPlan(IQueryExpression queryExpression, Boolean shallow) +307 NHibernate.Impl.AbstractSessionImpl.CreateQuery(IQueryExpression queryExpression) +292 NHibernate.Linq.DefaultQueryProvider.PrepareQuery(Expression expression, IQuery& query, NhLinqExpression& nhQuery) +51 NHibernate.Linq.DefaultQueryProvider.Execute(Expression expression) +32 NHibernate.Linq.DefaultQueryProvider.Execute(Expression expression) +37 System.Linq.Queryable.FirstOrDefault(IQueryable`1 source) +251 UCommerce.EntitiesV2.Country.FirstOrDefault(Expression`1 expression) +48 AMS101.masterpages.Checkout.CalculateShipping() in c:\dev\AMS101\AMS101.02\AMS101-branch\AMS101\masterpages\Checkout.master.cs:286 AMS101.masterpages.Checkout.lbtnContinue_Command(Object sender, CommandEventArgs e) in c:\dev\AMS101\AMS101.02\AMS101-branch\AMS101\masterpages\Checkout.master.cs:168 System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +111 System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +156 System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +9643314 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724
I have gotten around the issue by getting my own Eunmerable by
Enumerable.First<Country>( Country.All(), x => x.TwoLetterISORegionName == "AU" );
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.
Continue discussion
Error searching for finding country with Two Letter ISO Region Name
In my code i have
Country.FirstOrDefault( x => x.TwoLetterISORegionName == "AU" );
AU is country code for australia. Australia is in my list of countries and it has the code of AU however this throws an exception
could not resolve property: TwoLetterISORegionName of: UCommerce.EntitiesV2.Country
NHibernate.QueryException: could not resolve property: TwoLetterISORegionName of: UCommerce.EntitiesV2.Country [.FirstOrDefault[UCommerce.EntitiesV2.Country](.Where[UCommerce.EntitiesV2.Country](.Select[UCommerce.EntitiesV2.Country,UCommerce.EntitiesV2.Country](NHibernate.Linq.NhQueryable`1[UCommerce.EntitiesV2.Country], Quote((entity, ) => (entity)), ), Quote((x, ) => (String.op_Equality(x.TwoLetterISORegionName, p1))), ), )]
I have gotten around the issue by getting my own Eunmerable by
Enumerable.First<Country>( Country.All(), x => x.TwoLetterISORegionName == "AU" );
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.