请教一个NHibernate的多表查询的问题

Question

最近刚学习NHibernate，但是做一个多表查询就出了问题 _session.CreateQuery("select distinct c from Usr c ,"                + " c.OrderTbls o where o.OrderDesc like :orderDate").SetString("orderDate", "%" + strOrderDesc + "%")                .List<Usr>();上面是我写的HQL，但总是报c.OrderTbls is not mapped [select distinct c from myProject.Model.Usr c , c.OrderTbls o where o.OrderDesc like :orderDate]

Answer 1

left join fetch c.OrderTbls o 试试

Answer 2

集合需要join查询。。