在复杂场景中使用NHibernate QueryOver [英] Using NHibernate QueryOver with a complex scenario
本文介绍了在复杂场景中使用NHibernate QueryOver的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
在这种情况下,我正在尝试使用QueryOver:
I´m trying to use QueryOver in that scenario :
public class Class1
{
public virtual string Name { get; set; }
public virtual string Descripton { get; set; }
public virtual Class2 { get; set; }
public virtual IList<Class3> ListClass3{ get; set; }
... //SEVERAL OTHERS LISTS, PROPERTIES
}
public class Class2
{
public virtual string Name { get; set; }
... //SEVERAL OTHERS LISTS, PROPERTIES
}
public class Class3
{
public virtual string Name { get; set; }
public virtual Class4 { get; set; }
... //SEVERAL OTHERS LISTS, PROPERTIES
}
public class Class4
{
public virtual string Prop1 { get; set; }
public virtual string Prop2{ get; set; }
... //SEVERAL OTHERS LISTS, PROPERTIES
}
还有我的DTO:
public class ClassDTO
{
public string NameClass1 { get; set; }
public string DescriptonClass1 { get; set; }
public string NameClass2 { get; set; }
public virtual IList<Class3> Class3List { get; set; }
}
我的问题是如何获取IList ...否则,到目前为止效果还不错:
My problem is how get the IList ... Without that, thats working fine so far:
Class2 class2 = null;
IList<Class3> listClass3 = null;
var queryOver = Session.QueryOver<clsClass1>();
var list = queryOver
.JoinAlias(x => x.Class2, () => class2)
.JoinAlias(x => x.ListClass3, () => listClass3, JoinType.LeftOuterJoin)
.SelectList(list => list
.Select(c2 => c2.Name).WithAlias(() => myDTO.NameClass1)
.Select(c2 => class2.Name).WithAlias(() => myDTO.NameClass2)
//NEED GET LIST<CLASS3>
)
.TransformUsing(Transformers.AliasToBean<ClassDTO>())
.List<ClassDTO>();
那很好,但是我现在需要'填充'IList ...如果可能的话,只从Class4中获取Prop1和Prop2 ...
Thats working fine, but I need to 'fill' the IList now... And if possible, get just the Prop1 and Prop2 from Class4...
谢谢
推荐答案
一次往返所需的东西
// get ClassDTOs
Class2 class2 = null;
ClassDTO myDTO = null;
var results = Session.QueryOver<Class1>()
.JoinAlias(x => x.Class2, () => class2)
.SelectList(list => list
.Select(c1 => c1.Id).WithAlias(() => myDTO.IdClass1)
.Select(c1 => c1.Name).WithAlias(() => myDTO.NameClass1)
.Select(c1 => c1.Description).WithAlias(() => myDTO.DescriptionClass1)
.Select(() => class2.Name).WithAlias(() => myDTO.NameClass2)
)
.TransformUsing(Transformers.AliasToBean<ClassDTO>())
.Future<ClassDTO>();
// get Class3DTOs
Class3 class3 = null;
Class3DTO myClass3DTO = null;
var subresults = Session.QueryOver<Class1>()
.JoinAlias(x => x.Class3List , () => class3)
.JoinAlias(() => classe3.Class4 , () => class4)
.SelectList(list => list
.Select(c => c.Id)
.Select(() => class3.Name)
.Select(() => class4.Prop1)
.Select(() => class4.Prop2))
.Future<object[]>()
.ToLookup(array => (int)array[0], array => new myClass3DTO
{
NameClass3 = (string)array[1],
Prop1Class4 = (string)array[2],
Prop2Class4 = (string)array[3],
});
// assigne the lists to the dto
foreach (var result in results)
{
result.ListClass3 = subresults[result.IdClass1].ToList();
}
return results;
这篇关于在复杂场景中使用NHibernate QueryOver的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文