score:1

Accepted answer
var userandlovedonesquery = await (
    from uq in _context.users
    where uq.subjectid == request.subjectid
    select new
    {
        user = (from p in _context.persons
                where p.id == uq.personid
                select p)
            .include(x => x.primaryphonenumber)
            .firstordefault(),
        lovedones = (from profilegroup in _context.profilegroups where profilegroup.userid == uq.id
                    join profilegroupdetail in _context.profilegroupdetails on profilegroup.id equals profilegroupdetail.profilegroupid
                    join person in _context.persons on profilegroupdetail.personid equals person.id
                    select person).include(u => u.primaryphonenumber)
            .tolist(),
    }).firstordefaultasync(cancellationtoken);

Related Query

More Query from same tag