NHibernate throwing 'could not resolve property' exception

Question

I have the following Company with the attribute below (excluding Id):

    public virtual Category Category { get; set; }

That is mapped in a CompanyMap like this:

    HasOne(x => x.Category)
            .Cascade.All();

The Category has only the attribute:

    public virtual string Name { get; set; }

The CategoryMap:

    Map(x => x.Name)
            .Column("Name")
            .Length(40)
            .Unique();

The table is successfully created in the DB.

I have a repository with the following queryover:

            var test = Session.QueryOver<Company>()
                              .WhereRestrictionOn(dbCompany => dbCompany.Category.Name)
                              .IsLike(category.Name);

category.name is just any string.

Then I want to access the DB and get the results with:

    var result = test.List();

I get the following exception:

    could not resolve property: Category.Name of: My.Name.Space.Company

What is wrong with the query over?

Najera · Accepted Answer · 2015-04-21 17:43:53Z

6

You are missing the join to Category.

Try this:

Category catAlias = null;

var test = Session.QueryOver<Company>()
    .Left.JoinAlias(x => x.Category, () => catAlias) // Left is optional
    .WhereRestrictionOn(() => catAlias.Name)
    .IsLike(category.Name);

answered Apr 21, 2015 at 17:43

Najera

2,8793 gold badges30 silver badges52 bronze badges

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

Collectives™ on Stack Overflow

NHibernate throwing 'could not resolve property' exception

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related