I am creating a list and want to include columns from multiple tables. Here is my code:

var jobAssignments = new List<JobAssignment>
                new JobAssignment { JobID = jobs.Single (j => j.Status == Status.New, j => j.Priority == Priority.High).JobID,
                    TechnicianID = technicians.Single(c => c.LastName == "Dion").TechnicianID,
                    AssignmentDate = DateTime.Parse("2005-09-01")}

I want to display Status and Priority which come from the table "Job" I also want to display LastName which comes from technician and Assignment date which comes from JobAssignment table.

I assume that the "jobs.Single" is wrong, but what do i replace this with?

Related posts

Recent Viewed