c# - 具有多个提取和多个条件的 Nhibernate 查询

Question

当像这样使用 Entity Framework linq 时，如何使用 NHibernate QueryOver 获得相同的结果。

var result = items
   .include("subEntity1")
   .include("subEntity2")
   .include("subEntity3")
   .where(...).skip(x).take(y); 

Answer 1

QueryOver 的语法如下所示:

var query = session.QueryOver<MyEntity>()
    // force the collection inclusion
    .Fetch(x => x.Collection1).Eager
    .Fetch(x => x.Collection2).Eager
    ...
    // force the relations inclusion
    .Fetch(x => x.SubEntity1).Eager
    .Fetch(x => x.SubEntity2).Eager
    ...
    // paging
    .Skip(x)
    .Take(y);

var list = query
     .List<MyEntity>();

来源:

• 15.5. Dynamic association fetching
• 16. QueryOver Queries