C#

var datas = (from j in dc.Jobs
            join p in dc.Projects on j.ProjectId equals p.Id
            join cty in dc.Cities on p.CityId equals cty.Id
            join cl in dc.CompanyLocations on p.LocationId equals cl.Id
            let jsdr = dc.JobStartDateRevisions.Where(q => q.JobId == j.Id)
                                               .OrderByDescending(q => q.Revision)
                                               .Take(1)
                                               .FirstOrDefault()

            join jss in dc.JobSequenceSheets on j.Id equals jss.JobId
            let lots = dc.JobSequenceSheets.Where(q => q.JobId == j.Id).Count()

            where (jsdr != null && jsdr.StartDate >= startDate && jsdr.StartDate <= endDate)

            select new
            {
                JobId = j.Id,
                JobNumber = j.JobNumber,
                Lots = j.Lots,

                StartDate = jsdr.StartDate,

                ProjectId = p.Id,
                ProjectNumber = p.ProjectNumber,
                ProjectName = p.ProjectName,

                CityId = cty.Id,
                City = cty.City1,

                LocationId = cl.Id,
                Location = cl.Location,

            }).OrderBy(x => x.Location)
              .ThenBy(x => x.ProjectName)
              .ThenBy(x => x.StartDate).ToList();