Click here to Skip to main content
14,877,943 members
Home / Discussions / C#
   

C#

 
GeneralRe: C# Unable to update data table values Pin
jschell17-Apr-21 7:09
Memberjschell17-Apr-21 7:09 
AnswerRe: C# Unable to update data table values Pin
Mou_kol10-Apr-21 3:00
MemberMou_kol10-Apr-21 3:00 
SuggestionRe: C# Unable to update data table values Pin
Richard Deeming11-Apr-21 21:23
mveRichard Deeming11-Apr-21 21:23 
GeneralRe: C# Unable to update data table values Pin
Mou_kol12-Apr-21 7:06
MemberMou_kol12-Apr-21 7:06 
QuestionHour and minute slider Pin
Valakik8-Apr-21 9:49
MemberValakik8-Apr-21 9:49 
AnswerRe: Hour and minute slider Pin
OriginalGriff8-Apr-21 22:20
mveOriginalGriff8-Apr-21 22:20 
AnswerRe: Hour and minute slider Pin
BillWoodruff9-Apr-21 4:19
mveBillWoodruff9-Apr-21 4:19 
QuestionC# Linq Get Count of Joined Records Pin
Kevin Marois8-Apr-21 9:34
professionalKevin Marois8-Apr-21 9:34 
I have the following query.

There is a one-to-many relationship between Jobs->JobSequenceSheets.

I'm joining to JobSequenceSheets. But what I really want is just the COUNT of the JobSequenceSheets records for each Job record.

I'm not sure how to do this. Can someone help?
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();
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.

AnswerRe: C# Linq Get Count of Joined Records Pin
OriginalGriff8-Apr-21 9:40
mveOriginalGriff8-Apr-21 9:40 
GeneralRe: C# Linq Get Count of Joined Records Pin
Kevin Marois8-Apr-21 9:50
professionalKevin Marois8-Apr-21 9:50 
GeneralRe: C# Linq Get Count of Joined Records Pin
OriginalGriff8-Apr-21 10:05
mveOriginalGriff8-Apr-21 10:05 
QuestionClient Server Pin
Member 141922168-Apr-21 8:18
MemberMember 141922168-Apr-21 8:18 
AnswerRe: Client Server Pin
OriginalGriff8-Apr-21 8:45
mveOriginalGriff8-Apr-21 8:45 
AnswerRe: Client Server Pin
SeanChupas8-Apr-21 9:26
MemberSeanChupas8-Apr-21 9:26 
GeneralRe: Client Server Pin
Member 141922168-Apr-21 10:53
MemberMember 141922168-Apr-21 10:53 
GeneralRe: Client Server Pin
Dave Kreskowiak8-Apr-21 12:12
mveDave Kreskowiak8-Apr-21 12:12 
AnswerRe: Client Server Pin
Dave Kreskowiak8-Apr-21 10:34
mveDave Kreskowiak8-Apr-21 10:34 
AnswerRe: Client Server Pin
Mycroft Holmes8-Apr-21 12:24
professionalMycroft Holmes8-Apr-21 12:24 
GeneralRe: Client Server Pin
jschell9-Apr-21 14:44
Memberjschell9-Apr-21 14:44 
AnswerRe: Client Server Pin
jschell9-Apr-21 14:49
Memberjschell9-Apr-21 14:49 
QuestionCheck List Box Posting back to SQL Column Pin
Mike Mullins 20218-Apr-21 5:29
MemberMike Mullins 20218-Apr-21 5:29 
AnswerRe: Check List Box Posting back to SQL Column Pin
Mycroft Holmes8-Apr-21 12:28
professionalMycroft Holmes8-Apr-21 12:28 
GeneralRe: Check List Box Posting back to SQL Column Pin
Mike Mullins 20219-Apr-21 3:44
MemberMike Mullins 20219-Apr-21 3:44 
GeneralRe: Check List Box Posting back to SQL Column Pin
Mycroft Holmes9-Apr-21 12:17
professionalMycroft Holmes9-Apr-21 12:17 
QuestionNavigate to file, rename and move in mvc net core app Pin
Lmm Cams7-Apr-21 9:03
MemberLmm Cams7-Apr-21 9:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.