Hi,

I have a Human entity that has an EntitySet property containing Pet entities. I want to select all humans + a string concatenation of their pet's names. For example:

from human in session.Query.All<Human>()
select new {
   Id = human.Id,
   Name = human.Name,
   PetNames = human.Pets.Select(pet => pet.Name)
}

Then I print string.Join(", ", human.PetNames).

Unfortunately, this causes many queries (1 to query all humans, then 1 query to fetch each pet's name). I'd like all of this done in 1 query.

I can't include the string.Join() in the initial projection, because the LINQ translator doesn't support it. Can I write a custom translator for it? Any guidance you can provide?

Thank you!