<![CDATA[Latest posts for the topic "Sample query to use with XXXFactory.LoadXXXByQuery(...,...)"]]> http://forums.visual-paradigm.com/posts/33.html JForum - http://www.jforum.net Sample query to use with XXXFactory.LoadXXXByQuery(...,...)
Example,

Code: 
 
 Car car = CarFactory.LoadCarByQuery("where car.Owner.ORMID = '1'", null)


Basically I am trying to get a car owned by a specific Owner. But NHibernate keeps throwing exception like so..

Code: 
 
 could not resolve property:Owner of :Lesen.Car [From Lesen.Car as Car Where Car.Owner.ORMID = '1']


Lesen is the package name for my classes.

Any code sample that explains how to use this function would be good.]]> http://forums.visual-paradigm.com/posts/2085#16618.html http://forums.visual-paradigm.com/posts/2085#16618.html Re:Sample query to use with XXXFactory.LoadXXXByQuery(...,...)
Try this:

Car car = CarFactory.LoadCarByQuery("Car.owner.id = 1", null);

PS. Notice that the statement is case sensitive. We assume that Car starts with capital letter 'C', and owner starts with small letter 'o'.

Best regards,
Jick]]> http://forums.visual-paradigm.com/posts/2085#16638.html http://forums.visual-paradigm.com/posts/2085#16638.html Sample query to use with XXXFactory.LoadXXXByQuery(...,...)
So the correct query is "Car.ORM_Owner.Id = 1"

Everything work fine now. TQ.]]> http://forums.visual-paradigm.com/posts/2085#16645.html http://forums.visual-paradigm.com/posts/2085#16645.html Re:Sample query to use with XXXFactory.LoadXXXByQuery(...,...) http://forums.visual-paradigm.com/posts/2085#16657.html http://forums.visual-paradigm.com/posts/2085#16657.html