I want to concatenate strings inside my linq query but I also want to await.
This query works since I use AsEnumerable

var myquery=  ctx.PersonnelSubstitutes.AsEnumerable().Where(x => shiftTeam.PersonnelIds.Contains(x.PersonnelId) && x.FromTime <= now && x.ToTime >= now)
    .Select(x => new
    {
        FirstName= x.Person.FirstName,
        LastName= x.Person.LastName,
        WifeName= x.Relation.FirstName,
        
        text = $"{x.Person.FirstName} married to {x.Relation.FirstName}"
    }).ToList();

But I cant use await keyword on this.

So how to use await keyword and also get concatenated text?