I have the following Criteria query (using Lambda extensions):
var workflowResult = repository.GetSession()
.CreateCriteria<Core.Domain.Application>()
.SetFetchMode<Core.Domain.Application>(app =>
app.ApplicationWorkflows, FetchMode.Join)
.Add(SqlExpression.In<Core.Domain.Application>(app =>
app.ID, uniqueIds))
.SetResultTransformer(new
DistinctRootEntityResultTransformer())
.Future<Core.Domain.Application>();
This is working correctly. Each Application eagerly loads the
ApplicationWorkflows collection. However, I'd like to go one deeper
and load the ApplicationStatus object of each ApplicationWorkflow. I
can do this with the following HQL but would like to translate to
Criteria:
var workflowQuery = "SELECT DISTINCT app" +
" FROM Application app" +
" JOIN FETCH app.ApplicationWorkflows
awf" +
" JOIN FETCH awf.ApplicationStatus" +
" WHERE app.ID IN (:appList2)";
Thanks!
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
