There are at least 6 tables (classes) involved, and about 60 columns. I made an attempt to simplify things by referencing the columns involved the GroupBy and OrderBy.
yij sun's solution works, however none of the other columns and related tables are in the final result, and I don't have the understanding of Linq to fix that myself.
Linq so far has been a journey with more questions, less readability, and unexpected pitfalls (like this GroupBy/OrderBy). I looked at LinqPad real quick, and it seems like a nice tool for someone who understands Linq.
Click on "Mark as Answer" if my answers help you along.
Contributor
2619 Points
2753 Posts
Re: groupby and orderby thenorderby - results not as expected
May 30, 2020 12:49 PM|wavemaster|LINK
calOId
cal for calendar
O for Order
Id for identity
There is nothing else that looks like calOId.
There are at least 6 tables (classes) involved, and about 60 columns. I made an attempt to simplify things by referencing the columns involved the GroupBy and OrderBy.
yij sun's solution works, however none of the other columns and related tables are in the final result, and I don't have the understanding of Linq to fix that myself.
Linq so far has been a journey with more questions, less readability, and unexpected pitfalls (like this GroupBy/OrderBy). I looked at LinqPad real quick, and it seems like a nice tool for someone who understands Linq.