Nhibernate Projection over nested nested properties

Question

I have domain class location

    public abstract class BaseEntity<T> where T: struct 
    {
    public virtual T Id { get; set; }
    public virtual bool Equals(BaseEntity<T> other)
    }

    public class Location : BaseEntity<Int32>
    {

    public  User User {get;set;}
    }

    public class User : BaseEntity<Int32>
    {
    public string Name {get;set;
    }

    public OtherInfo Otherinfo {get;set;};
     }
    public class OtherInfo
    {
    public  string preference {get;set;};
    }

    var criteria = session.CreateCriteria(typeof(Location), "alias");
    criteria.CreateCriteria("User", "user", JoinType.InnerJoin);
    criteria.CreateCriteria("user.Otherinfo", "userInfo",JoinType.InnerJoin); 
    criteria.Add(Restrictions.Eq("user.Id", 100));
    criteria.SetProjection(Projections.Alias(Projections.Id(), "Id"),                            Projections.Alias(Projections.Property("user.Name"), "Name"),  Projections.Alias(Projections.Property("userInfo.preference "), "pref"));

now when i execute above criteria, it gives error on userInfo.preference. {NHibernate.QueryException: could not resolve property: Otherinfo of: Location.User What is mistake here. is it because of multi nested objects

Answer 1

Use CreateAlias instead:

criteria.CreateAlias("User", "user", JoinType.InnerJoin);
criteria.CreateAlias("user.Otherinfo", "userInfo",JoinType.InnerJoin); 

Answer 2

This is for someone else looking for nested projections and nested join with NHibernate Criteria:

public class A
{
    public B {get;set;}
    public string PropertyA {get;set;}
}
public class B
{
    public C {get;set;}
}    
public class C
{
    public string CName {get;set;}
}
//you want to project and join 3 tables querying from A and get CName of C
//  InstanceA.B.C.CName

you cannot use "." dot as your alias name + you can only access 1 level deep within an alias(aliasA.PropertyA)

//you have to create 3 alias for each class/instance/table
DetachedCriteria joinNested3tables = DetachedCriteria.For<A>("aliasA") //level 1 alias
            .CreateAlias("aliasA.B", "aliasB", JoinType.InnerJoin) //level 2 alias
            .CreateAlias("aliasB.C", "aliasC", JoinType.InnerJoin) //level 3 alias
          .SetProjection(Projections.ProjectionList()
            .Add(Projections.Property("aliasC.CName"), "CNameProjection")
            //you cannot have more than 1 dot operator like below
            //.Add(Projections.Property("aliasB.C.CName"), "CNameProjection")
            );