asp.net core How do I implement GroupBy twice?

class="col-md-2">

class="form-control text-white" style="background-color:mediumorchid">Responsible:

class="row no-gutters">

class="col-md-1">

class="form-control">@Html.DisplayFor(model => group1.Key)

class="col-md-11">

@foreach (var item in group1.OrderBy(s => s.StepNo).ThenBy(s => s.Hazard))

{

class="row no-gutters">

class="col-md-3">

class="form-control">@Html.DisplayFor(modelItem => item.ActivitySec)

class="col-md-2">

class="form-control">@Html.DisplayFor(modelItem => item.Hazard)

class="col-md-2">

class="form-control">@Html.DisplayFor(modelItem => item.Controls)

class="col-md-2">

class="form-control">@Html.DisplayFor(modelItem => item.PPE)

class="col-md-2">

class="form-control">@Html.DisplayFor(modelItem => item.Responsible)

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
yes, this is a group by multiple keys, we achieve this using an anonymous object. like GroupBy(x=>new{key1,key2})
please visit the link given below, for a better understanding of Group By.

https://www.sharpencode.com/article/Linq/grouping-operator

Also, keep in mind that SQL Group by very different from Linq Group By.
Marius Vasile5y ago
Fixed by adding
@foreach (var group1 in Model.JSAViewList.GroupBy(s => new {s.StepNo, s.ActivitySec }))