How to join chain of Content Parts?

Topics: Core, Customizing Orchard, General
Oct 13, 2014 at 10:16 AM
Edited Oct 13, 2014 at 10:16 AM
Hi all,
How I can join of chain of content parts?
I have a "Document" which contains CommonPart. I need select query with order on Owner Name.
I need join DocumentPart with CommonPart and join with UserPart on CommonPart.OwherId=UserPart.Id.
I have an IContentQuery<DocumentPart, DocumentPartRecord> query. I need query
uName = query.Join<CommonPartRecord>().Join<UserPartRecond>(). But UserPartRecord NHibernate query join with DocumentPartRecord on Id. I need join this 3 tables on
(DocumentPartRecord.Id = CommonPartRecord.Id) and (UserPartRecord.Id = CommonPart Record.OwherId).

Is exists the way to do this?