public async Task <Event> GetByIdWithIncludedRoomsAndMatches(string id) => await CurrentDbSet .Include(x => x.Rooms) .ThenInclude(x => x.Matches) .Include(x => x.Rooms) .ThenInclude(x => x.SportType) .FirstOrDefaultAsync(x => x.Id == id);
public async Task <GameRoom> GetByIdWithIncludedEventAndModeratorsJoinObject(int id)
{
return(await CurrentDbSet
.Include(x => x.Event)
.ThenInclude(x => x.Moderators)
.FirstOrDefaultAsync(x => x.Id == id));
}
public async Task <Match> GetMatchWithIncludedRoomEventModeratorsJoinObject(string id)
{
return(await CurrentDbSet
.Include(x => x.Room)
.ThenInclude(x => x.Event)
.ThenInclude(x => x.Moderators)
.FirstOrDefaultAsync(x => x.Id == id));
}
/// <summary>
/// Gets the vendor community.
/// </summary>
/// <param name="orgId">The org identifier.</param>
/// <returns></returns>
public IEnumerable <Vendor> GetVendorWorkerCommunity(int orgId)
{
return(CurrentDbSet.Include(vendor => vendor.VendorWorkers));
}
public Event GetByIdWithIncludedModerators(string id)
{
return(CurrentDbSet.Include(x => x.Moderators).ThenInclude(x => x.User).FirstOrDefault(x => x.Id == id));
}