public override async Task <IQueryable <ChangeSetDto> > GetAll(CancellationToken cancellationToken) { // We can declare a view for following sql query in database and then map our dto directly to view using ef db context: // select *, (case (((select count(1) from Deliveries as Delivery where ChangeSet.Id = Delivery.ChangeSetId ))) when (select count(1) from Customers) then 1 else 0 end) as IsDeliveredToAll from ChangeSets as ChangeSet // or we can use ef core execute sql which returns IQueryable // Note: _changeSetsRepository.GetAll(changeSet => new ChangeSetDto { Id = changeSet.Id , ... , IsDeliveredToAll = changeSet.Deliveries.Count() == customersQuery.Count() }); results into problematic sql. // The downside of following code are its database round trips. int customersCount = await(await CustomersRepository.GetAllAsync(cancellationToken)).CountAsync(cancellationToken); return(DtoEntityMapper.FromEntityQueryToDtoQuery((await Repository.GetAllAsync(cancellationToken)), parameters: new { customersCount = customersCount })); }
public virtual async Task <IQueryable <TDto> > GetAll(CancellationToken cancellationToken) { return(DtoEntityMapper.FromEntityQueryToDtoQuery(await Repository.GetAllAsync(cancellationToken).ConfigureAwait(false), membersToExpand: GetODataQueryOptions().GetExpandedProperties())); }
public virtual async Task <IQueryable <TDto> > GetAll(CancellationToken cancellationToken) { return(DtoEntityMapper.FromEntityQueryToDtoQuery(await Repository.GetAllAsync(cancellationToken))); }
public virtual async Task <SingleResult <CustomerDto> > GetCurrentCustomer(CancellationToken cancellationToken) { Guid customerId = Guid.Parse(UserInformationProvider.GetCurrentUserId()); return(SingleResult.Create(DtoEntityMapper.FromEntityQueryToDtoQuery((await CustomersRepository.GetAllAsync(cancellationToken)).Where(c => c.Id == customerId)))); }