Asp.net – How to get one of each type returned from an EF Core query
I'm trying to get a list of one of each of the type of notes of a client ordered by desc. In SQL Server, I wrote the following query SELECT note_id, st_id, note_type, signature_date FROM (SELECT note_id, st_id, note_type, signature_date…