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:
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! |
Hello Ara, I think, this is a nice case to utilize the power of Hope that helps. |