Nhibernate queryover with multiple join fail

Question

I have a nhibernate queryover like this:

var query = Session.QueryOver<Immobile>()
                                .WhereRestrictionOn(i => i.Agenzia.CodiceAgenzia).IsLike(codiceAgenzia)
                                .WhereRestrictionOn(i => i.StatoImmobile.StatoImmobileId).IsLike(statoId)
                                .And(i => i.Prezzo <= prezzo)
                                .And(i => i.Mq <= metriquadri);

The code compile but on execute I receive this exception:

could not resolve property: Agenzia.CodiceAgenzia of: Domain.Model.Immobile

What am I doing wrong?

Baz1nga · Accepted Answer · 2011-12-03 16:23:47Z

1

QueryOver syntax doesnt work that way unfortunately on Referenced objects you need to join them first and then add the restriction..

Change the code to as follows:

Azengia azengiaAlias=null;   //Azengia here is typeof(Immobile.Azengia) I am assuming it is Azengia
StatoImmobile statoImmobileAlias=null;  //similarly StatoImmobile is assumed to be typeof(Immobile.StatoImmobile)
var query=Session.QueryOver<Immobile>()
.Where(i => i.Prezzo <= prezzo && i.Mq <= metriquadri)
.Inner.JoinAlias(x=>x.Agenzia,()=>azengiaAlias)
.Inner.JoinAlias(x=>x.StatoImmobile,()=.statoImmobileAlias)
.WhereRestrictionOn(() => azengiaAlias.CodiceAgenzia).IsLike(codiceAgenzia)
.WhereRestrictionOn(() => statoImmobileAlias.StatoImmobileId).IsLike(statoId);

Hope this helps.

edited Dec 3, 2011 at 16:23

answered Dec 3, 2011 at 16:18

Baz1nga

15.6k3 gold badges38 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Baz1nga Over a year ago

let me know if you run into issus while using the quest and I should be able to help you out

Baz1nga Over a year ago

unfortunately not since you need to add restriction on more than one references you cannot avoid it.. you could probably do without one alias.. I dont understand why you are doing a like on the ID you could porbably just do an equals on the object and get away without joining..

Collectives™ on Stack Overflow

Nhibernate queryover with multiple join fail

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related