public TestResult GetTeamMemberByProject(int projectId) { Stopwatch watch = new Stopwatch(); watch.Start(); List <TeamMember> teamMembers = new List <TeamMember>(); TestResult result = new TestResult(); using (EfCoreDbContext context = new EfCoreDbContext(_connectionString)) { teamMembers = context.Teams.AsNoTracking() .Include(x => x.TeamMembers) .Where(x => x.ProjectID == projectId) .SelectMany(x => x.TeamMembers) .Select(x => new TeamMember { ID = x.ID, DateOfBirth = x.DateOfBirth, FirstName = x.FirstName, LastName = x.LastName, TeamID = x.TeamID }).OrderBy(x => x.FirstName).ToList(); } watch.Stop(); result.MemberCount = teamMembers.Count; result.Time = watch.ElapsedMilliseconds; return(result); }
public TestResult GetTeamMemberByID(int id) { Stopwatch watch = new Stopwatch(); watch.Start(); TestResult result = new TestResult(); using (EfCoreDbContext context = new EfCoreDbContext(_connectionString)) { var teamMemberEF = context.TeamMembers.Find(id); _ = new TeamMember() { ID = teamMemberEF.ID, DateOfBirth = teamMemberEF.DateOfBirth, FirstName = teamMemberEF.FirstName, LastName = teamMemberEF.LastName, TeamID = teamMemberEF.TeamID }; } watch.Stop(); result.MemberCount = 1; result.Time = watch.ElapsedMilliseconds; return(result); }