May 30, 2020 12:49 PM|wavemaster|LINK
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.