Medium article - direct fetch with eager loading

direct_fetch.cs

var envIds = new List<int> {5};
DateTime fromDate = DateTime.Now.AddDays(-7).Date;
DateTime toDate = DateTime.Now.Date.AddDays(1).AddSeconds(-1);

var results = DataAccess.ImportingSystemTestResultRepository.All
    .Include(tr => tr.ImportingSystemTestRunTime)
    .Include(tr => tr.ImportingSystemTestQueue)
    .Include(tr => tr.ImportingSystemTest)
    .Include(tr => tr.ImportingSystem)
    .Include(tr => tr.Environment)
    .Include(tr => tr.AppUser)
    .Select(tr => new
    {
        tr.ImportingSystemTestResultId,
        tr.EnteredTimestamp,
        tr.RunTimestamp,
        tr.ImportingSystemTestId,
        tr.EnvironmentId,
        tr.ImportingSystemTestExecutionStatusId,
        tr.ImportingSystemTestQueue.RequestId,
        tr.ImportingSystemTestRunTime.FirstOrDefault().DurationMs,
        tr.ImportingSystemTest.TestName,
        tr.ImportingSystem.ImportingSystemName,
        tr.Environment.Name,
        FullName = tr.AppUser.LastName + " " + tr.AppUser.FirstName
    })
    .Where(x => x.EnteredTimestamp >= fromDate && x.EnteredTimestamp <= toDate)
    .Take(500)
    .ToList();