In #3, your query will not work since its not an IEnumerable. Shape is
just a single object. I tried below test and I get different Error.
Looks like its not looking at Any mapping to get the meta-value value.
In this case Circle = 1.
[Test]
public void Test44()
{
var entity = Repository.Session.QueryOver<ToyBox>()
.Where(x => x.Shape.GetType() ==
typeof(Circle)).List();
Assert.IsNotNull(entity);
}
Execute
NHibernate.Exceptions.GenericADOException: could not execute query
[ SELECT this_.toybox_id as toybox1_5_0_, this_.name as name5_0_,
this_.s_object_id as s3_5_0_, this_.object_id as object4_5_0_ FROM
toyBox this_ WHERE this_.s_object_id = ? ]
Positional parameters: #0>Touchcom.Objects.Entities.Circle
[SQL: SELECT this_.toybox_id as toybox1_5_0_, this_.name as name5_0_,
this_.s_object_id as s3_5_0_, this_.object_id as object4_5_0_ FROM
toyBox this_ WHERE this_.s_object_id = ?] --->
System.InvalidCastException: Unable to cast object of type
'System.RuntimeType' to type 'System.String'.
On Sep 10, 12:58 pm, José F. Romaniello <[email protected]>
wrote:
> 1-Yes it is a bug in the linq provider. You can submit a test case to the
> issue trackerhttp://jira.nhforge.org/
> 2-I dont like your QueryOver query Where(x => x.Shape == new Circle { Id =
> 1})) ... Its feel just wrong.
>
> 3-In the first mail you said, "Can I find all Circles in the ToyBox
> using linq?" So I wonder if the query you are looking for is something like
> this:
>
> session.Query<ToyBox>().Where(tb => tb.Id = someId...).Select(tb =>
> tb.Shape.OfType<Circle>()).First()...
>
> Or something like that?
> I don't know if this work, it could fail too... But i think this is the
> query you need.
>
> 2010/9/10 MichaelK <[email protected]>
>
> > Sorry for the mass updates but I keep getting closer. I got it working
> > with QueryOver, but Linq fails. I have two UnitTests below. One using
> > QueryOver<> that WORKS, and second using Linq that fails. Is this a
> > bug with the Linq provider?? Also note how I had to create a circle
> > as well for the query to work. I still would like to get all ToyBoxes
> > with Shape of type Circle.
>
> > [Test]
> > public void Test()
> > {
> > var entity = Repository.Session.QueryOver<ToyBox>()
> > .Where(x => x.Shape == new Circle { Id =
> > 1 }).SingleOrDefault();
> > Assert.IsNotNull(entity);
> > }
>
> > [Test]
> > public void Test1()
> > {
> > var entity = Repository.Session.Query<ToyBox>()
> > .Where(x => x.Shape == new Circle { Id =
> > 1 }).SingleOrDefault();
> > Assert.IsNotNull(entity);
> > }
>
> > On Sep 10, 12:18 pm, MichaelK <[email protected]> wrote:
> > > Little more info to help figure out what is going on. When I use
> > > QueryOver<>.Where(x => x.Shape is Cirlce) I get this error
>
> > > Execute
> > > System.Exception: Could not determine member type from (x.Shape
> > Is
> > > Circle)
> > > at
> > > NHibernate.Impl.ExpressionProcessor.ProcessBooleanExpression(Expression
> > > expression)
> > > at
> > NHibernate.Impl.ExpressionProcessor.ProcessExpression(Expression
> > > expression)
> > > at
>
> > NHibernate.Impl.ExpressionProcessor.ProcessLambdaExpression(LambdaExpression
> > > expression)
> > > at NHibernate.Impl.ExpressionProcessor.ProcessExpression[T]
> > > (Expression`1 expression)
> > > at NHibernate.Criterion.QueryOver`2.Add(Expression`1 expression)
> > > at NHibernate.Criterion.QueryOver`2.Where(Expression`1
> > expression)
> > > at
>
> > NHibernate.Criterion.QueryOver`2.NHibernate.IQueryOver<TRoot,TSubType>.Where(Expression`1
> > > expression)
> > > DogRepositoryTests.cs(32,0): at
> > > NHibernateScratchpad.Tests.ToyBoxRepositoryTests.Test()
>
> > > On Sep 10, 12:01 pm, MichaelK <[email protected]> wrote:
>
> > > > The above queries do not work. Here is a working example with mapping
> > > > and classes
>
> > > > Cirlce, Square, Triangle all implement IShape. ToyBox entity has a
> > > > property called Shape.
>
> > > > public class Circle : IShape
> > > > {
> > > > public virtual int Id { get; set; }
> > > > public virtual string Color { get; set; }
> > > > }
>
> > > > public class Square : IShape
> > > > {
> > > > public virtual int Id { get; set; }
> > > > public virtual string Color { get; set; }
> > > > }
>
> > > > public class Triangle : IShape
> > > > {
> > > > public virtual int Id { get; set; }
> > > > public virtual string Color { get; set; }
> > > > }
>
> > > > public class ToyBox
> > > > {
> > > > public virtual int Id { get; set; }
> > > > public virtual string Name { get; set; }
> > > > public virtual IShape Shape { get; set; }
> > > > }
>
> > > > <?xml version="1.0" encoding="utf-8" ?>
> > > > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="Test"
> > > > namespace="Test">
>
> > > > <class name="Circle" table="circles">
> > > > <id column="circle_id" name="Id" type="int">
> > > > <generator class="identity"/>
> > > > </id>
> > > > <property name="Color" column="color" />
> > > > </class>
>
> > > > <class name="Square" table="squares">
> > > > <id column="square_id" name="Id" type="int">
> > > > <generator class="identity"/>
> > > > </id>
> > > > <property name="Color" column="color" />
> > > > </class>
>
> > > > <class name="Triangle" table="triangles">
> > > > <id column="triangle_id" name="Id" type="int">
> > > > <generator class="identity"/>
> > > > </id>
> > > > <property name="Color" column="color" />
> > > > </class>
>
> > > > <class name="ToyBox" table="toyBox">
> > > > <id column="toybox_id" name="Id" type="int">
> > > > <generator class="identity"/>
> > > > </id>
> > > > <property name="Name" column="name" />
> > > > <any name="Shape" id-type="int" meta-type="int">
> > > > <meta-value value="1" class="Circle"/>
> > > > <meta-value value="2" class="Square"/>
> > > > <meta-value value="3" class="Triangle"/>
> > > > <column name="s_object_id" not-null="true"/>
> > > > <column name="object_id" not-null="true"/>
> > > > </any>
> > > > </class>
> > > > </hibernate-mapping>
>
> > > > I can get a ToyBox by ID and when I look at the Shape Property its
> > > > hydrated properly.
>
> > > > BUT I can not query on Shape. The below query fails
>
> > > > var entity = Session.Query<ToyBox>().Where(x => x.Shape is
> > > > Circle).FirstOrDefault();
>
> > > > Error:
> > > > System.NullReferenceException: Object reference not set to an instance
> > > > of an object.
> > > > at
>
> > NHibernate.Hql.Ast.ANTLR.SessionFactoryHelperExtensions.FindSQLFunction(String
> > > > functionName)
> > > > at NHibernate.Hql.Ast.ANTLR.Tree.IdentNode.get_DataType()
> > > > at
>
> > NHibernate.Hql.Ast.ANTLR.Tree.BinaryLogicOperatorNode.ExtractDataType(IASTNode
> > > > operand)
> > > > at
> > NHibernate.Hql.Ast.ANTLR.Tree.BinaryLogicOperatorNode.Initialize()
> > > > at
> > > > NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.PrepareLogicOperator(IASTNode
> > > > operatorNode)
> > > > at NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.comparisonExpr()
> > > > at NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.logicalExpr()
> > > > at NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.whereClause()
> > > > at NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.unionedQuery()
> > > > at NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.query()
> > > > at NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.selectStatement()
> > > > at NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.statement()
> > > > at NHibernate.Hql.Ast.ANTLR.HqlSqlTranslator.Translate()
> > > > at NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.Analyze(String
> > > > collectionRole)
> > > > at
> > > > NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.DoCompile(IDictionary`2
> > > > replacements, Boolean shallow, String collectionRole)
> > > > at
> > NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.Compile(IDictionary`2
> > > > replacements, Boolean shallow)
> > > > 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, String
> > > > collectionRole, Boolean shallow, IDictionary`2 filters,
> > > > ISessionFactoryImplementor factory)
> > > > at
> > > > NHibernate.Engine.Query.HQLExpressionQueryPlan.CreateTranslators(String
> > > > expressionStr, IQueryExpression queryExpression, String
> > > > collectionRole, Boolean shallow, IDictionary`2 enabledFilters,
> > > > ISessionFactoryImplementor factory)
> > > > at NHibernate.Engine.Query.HQLExpressionQueryPlan..ctor(String
> > > > expressionStr, IQueryExpression queryExpression, String
> > > > collectionRole, Boolean shallow, IDictionary`2 enabledFilters,
> > > > ISessionFactoryImplementor factory)
> > > > at NHibernate.Engine.Query.HQLExpressionQueryPlan..ctor(String
> > > > expressionStr, IQueryExpression queryExpression, Boolean shallow,
> > > > IDictionary`2 enabledFilters, ISessionFactoryImplementor factory)
> > > > at
> > > > NHibernate.Engine.Query.QueryPlanCache.GetHQLQueryPlan(IQueryExpression
> > > > queryExpression, Boolean shallow, IDictionary`2 enabledFilters)
> > > > at
> > > > NHibernate.Impl.AbstractSessionImpl.GetHQLQueryPlan(IQueryExpression
> > > > queryExpression, Boolean shallow)
> > > > at
> > NHibernate.Impl.AbstractSessionImpl.CreateQuery(IQueryExpression
> > > > queryExpression)
> > > > at NHibernate.Linq.NhQueryProvider.Execute(Expression
> > expression)
> > > > at NHibernate.Linq.NhQueryProvider.Execute[TResult](Expression
> > > > expression)
> > > > at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1
> > source)
> > > > DogRepositoryTests.cs(32,0): at
> > > > NHibernateScratchpad.Tests.ToyBoxRepositoryTests.Test()
>
> > > > On Sep 9, 7:19 pm, Fabio Maulo <[email protected]> wrote:
>
> > > > > I like the classes named "1" and "2"
>
> > > > > --
> > > > > Fabio Maulo
>
> > > > > El 09/09/2010, a las 17:45, MichaelK <[email protected]> escribió:
>
> > > > > > Is it possible to query an <Any/> collection by the type. Take the
> > > > > > pretend Any mapping below. Can I find all Circles in the ToyBox
> > using
> > > > > > linq?
>
> > > > > > <class name=ToyBox >
> > > > > > <any name="Items" meta-type="int" id-type="int">
> > > > > > <meta-value class="1" value="Square"/>
> > > > > > <meta-value class="2" value="Circle"/>
> > > > > > <column name="entityTypeId"/>
> > > > > > <column name="entityId"/>
> > > > > > </any>
> > > > > > </class>
>
> > > > > > Here is how I would have hoped to query it.
>
> > > > > > Session.Query<ToyBox>().Where(x => x.Items.GetType() ==
> > > > > > typeof(Circle))
>
> > > > > > --
> > > > > > You received this message because you are subscribed to the Google
> > Groups "nhusers" group.
> > > > > > To post to
>
> ...
>
> read more »
--
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.
