How to order child collections of entities in EF

My solution :

     var data = await db.lessonTasks
               .Select(res => new
               {
                   details = res,
                   appos  = res.appos.OrderBy(ap=>ap.dateTime).ToList(),
               })
               .OrderBy(r=>r.appos.First().dateTime)
               .ToListAsync();

You could load the data and sort in memory after loading it.

IEnumerable<Team> teams = _ctx.Teams
            .Include(x => x.TeamMembers)
            .Include(x => x.TeamMembers.Select(u => u.User))
            .Where(x => x.UserId == ownerUserId)
            .OrderBy(x => x.Name).ToList();

foreach (var team in teams)
{
    team.TeamMembers = team.TeamMembers.OrderBy(m => m.Name);
    foreach (var teamMember in team.TeamMembers)
    {
        teamMember.Users = teamMember.Users.OrderBy(u => u.Name);
    }
}

Or you could use Projections and use the Change Tracking of EF to sort your collection. Here is an example of filtering an Include but the same works for Ordering.

You could dump your teams and their team members into an anonymous type (probably not what you want), like this:

public IEnumerable<Team> GetAllTeamsWithMembers(int ownerUserId)
{
    return (from t in _ctx.Teams
        where t.UserId == ownerUserId
        select new {
            Team = t,
            TeamMembers = t.TeamMembers.OrderBy(m => m.Name)
        }).ToList()
}

You can then loop through them:

foreach(Team team in GetAllTeamsWithMembers(1234))
{
    string teamName = team.Team.Name;
    string firstTeamMemberName = team.TeamMembers.First().Name;
}

Update: For the record, my opinion is to not use this solution, but to sort each collection in a loop or during rendering/binding.

I removed the 2nd solution, since it was pointed out that EF cannot select into entities.