Untitled

RavenDB - Get IDs of root property within a non-root level property

IEnumerable<ApplicationServer> appServers = QueryAndCacheEtags(session =>

  session.Advanced.LuceneQuery<ApplicationServer>()

  .Include(x => x.CustomVariableGroupIds)

  // This is the line I'm trying to make work:

  .Include(x => (from item in x.ApplicationsWithOverrideGroup select item.ApplicationId).ToList())

  ).Cast<ApplicationServer>();

       

.Include(x => x.ApplicationsWithOverrideGroup)

       

.Include(x => x.ApplicationsWithOverrideGroup[0].ApplicationId)

       

// Not using this, at least for now, because it increased the NumberOfRequests on the session...

appServer.CustomVariableGroups = new ObservableCollection<CustomVariableGroup>(

QueryAndCacheEtags(session => session.Load<CustomVariableGroup>(appServer.CustomVariableGroupIds)).Cast<CustomVariableGroup>());

       

// ... however, this kept the NumberOfRequests to just one. Not sure why the difference.

appServer.CustomVariableGroups = new ObservableCollection<CustomVariableGroup>();

foreach (string groupId in appServer.CustomVariableGroupIds)

{                

  appServer.CustomVariableGroups.Add(QuerySingleResultAndCacheEtag(session => session.Load<CustomVariableGroup>(groupId)) as CustomVariableGroup);

}