.net Core 3.1 web app - querying a subset of a model

[JerryMungo]

.

 

[jackshiels]

Add a

@foreach (var item in Model.Mymodel.Where(c => c.Province == "province").ToList())

For every enumerated province

 

[jackshiels]

Ah, awesome, will give that a go, thanks!
What's the quickest way to get a list of unique provinces into an array and use that in another loop just before the table to repeat it for each?

Enumerate them, as you can iterate over an enum. You need to import the enum in the cshtml, though.

 

[_kabal_]

Look at .GroupBy or .ToLookup

 

[Hamster]

Look at .GroupBy or .ToLookup

This

Grouping Data - C#

Grouping puts data into groups of elements that share an attribute. Learn about the standard query operator methods in LINQ in C# that group data elements.

docs.microsoft.com