I´m trying that for a couple of days without success...
My classes :
public class ClassA : Entity
{
public virtual IList<ClassB> MyBClassList{ get; set; }
public virtual int MyIntA{ get; set; }
}
public class ClassB : Entity
{
public virtual ClassA MyClassA { get; set; }
public virtual ClassC MyClassC { get; set; }
public virtual double? MyValueB { get; set; }
}
public class ClassC : Entity
{
public virtual double? MyValueC1 { get; set; }
public virtual double? MyValueC2 { get; set; }
}
Ok, Now I trying to make my DTO Query :
var list = repositoryA.GetAll()
.Select(x => new
{
Id = x.Id,
MyInt = x.MyIntA,
BList = x.MyBClassList.DefaultIfEmpty()
.Select(y =>
{
y.MyValueB,
y.MyClassC.MyValueC1,
y.MyClassC.MyValueC2
}).ToList()
});
The Query executes without error, but I got duplicate rows of my BList, and strange results...
Why is that? What Am I doing wrong?
I´m using NHibernate 4.0.0.2 alpha...
Thanks