Projection Example

Ticket.cs

public static readonly Expression<Func<TicketAggregate, Ticket>> Projection =
    x => new Ticket()
    {
        ReportedBy = x.ReportedBy != null ? x.ReportedBy.Name : "",
        Client = x.Client != null ? x.Client.Name : "",
        Number = x.Number,
        Summary = x.Summary,
        Priority = x.Priority != null ? x.Priority.Name : "",
        Space = x.Space != null ? x.Space.Slug : "",
        Project = x.Project != null ? x.Project.Name : "",
        Status = x.Status != null ? x.Status.Name : "",
        IncomeCategory = x.IncomeCategory != null ? x.IncomeCategory.Name : "",
        AccountManager = x.Project != null && x.Project.AccountManager != null ? x.Project.AccountManager.Name : "",
        AssignedTo = x.AssignedTo != null ? x.AssignedTo.Name : "",
        Milestone = x.Milestone != null ? x.Milestone.Name : "",
        PreferredResource = x.PreferredResource != null ? x.PreferredResource.Name : "",
        StartDay = x.StartDay != null ? x.StartDay.Name : "",
        TicketId = x.Number,
        Description = x.Description,
        DueDate = x.DueDate,
        HoursRequested = x.TimeRequestedInHours,
        HoursWorked = x.TimeWorkedInHours,
        MoreTimeRequiredInNextMilestone = x.MoreTimeRequiredInNextMilestone,
        Rolling = x.Rolling,
        MilestoneId = x.MilestoneId,
        MilestoneStartDate = x.Milestone != null ? x.Milestone.StartDate : DateTimeOffset.UtcNow
    };

TIcketsQuery.cs

public async Task<Model> Handle(Request request, CancellationToken cancellationToken)
{
    var query = context.Tickets.AsNoTracking().AsQueryable();

    query = FilterQuery(query, request);

    var total = await query.CountAsync(cancellationToken);

    query = OrderQuery(query, request);
    query = PageQuery(query, request);

    var projection = query.Select(Ticket.Projection);
    var list = await projection.ToListAsync(cancellationToken);
    return new Model(list, total);
}