Question

nHibernate allows you to sort column names easily, so long as the column name matches the mapping. So, for example:

 Map(Function(x) x.CreatedOn)


 criteria = criteria.AddOrder(New Global.NHibernate.Criterion.Order("CreatedOn", True))

以上都是 board。

但我会遇到麻烦,难以按照从物体中推断的特性而不是直接绘制地图。我甚至不敢肯定后者是可能的。考虑如下:

 HasMany(Function(x) x.Shipments).Cascade.SaveUpdate()

Public Overridable ReadOnly Property Items() As IList(Of OrderItem)
    Get
        Return Shipments.SelectMany(Function(x) x.Items).ToList().AsReadOnly()
    End Get
End Property

如何按项目顺序排列。情况如何? ob:

criteria = criteria.AddOrder(New Global.NHibernate.Criterion.Order("Items.Count", True))

导致“不能解决财产:项目”的错误

Cheers, Matt

Answer 1

为了按部分顺序排列,你将具体说明财产名称,然后列出组成部分,只是询问你是否在法典中将财产名称从标物中获取。

criteria = criteria.AddOrder(New Global.NHibernate.Criterion.Order("Name.Surname", True))

至于你的第二个问题,这并不容易按标准完成,但可以很容易地用总部语言书写:

query = session.CreateQuery("select s from Shipment s order by size(s.Items)")

友情链接