Select Distinct record in LINQ Query

Question

I have comming multiple records in strongly typed list. I want distinct record with all columns based on AssessmentID column so for example I am getting two records with AssessmentID = 2455 so I want pick 2455 once in list

List<AssessmentWithRemidiationViewModel> activeAssessmentWithRemidiation = AssessmentRemidiationRelay.GetActiveAssessmentWithRemediation(null);
var query_b = (from b in activeAssessmentWithRemidiation
               where ((b.AssessorID == ContextSession.StaffID) 
                        || (b.ModuleLead == ContextSession.StaffID) 
                        || (b.SeniorStaffID == ContextSession.StaffID)) 
                        && b.ClinicalSupervisorCheck == true
                    select b).ToList();

well as no one can answer this so they mark as duplicate, any way I found asnwer and is as following;

My Answer

  var query_b = (from b in activeAssessmentWithRemidiation
                      where ((b.AssessorID == ContextSession.StaffID) || (b.ModuleLead == ContextSession.StaffID) || (b.SeniorStaffID == ContextSession.StaffID)) && b.ClinicalSupervisorCheck == true
                      select b).ToList();


       var filteredList = query_b.GroupBy(x => x.AssessmentID)
                          .Select(i=>i.First()).ToList();

There's a contradiction. You want distinct records according to all columns but also according to a single column `AssessmentID`. — Tim Schmelter, Dec 07 '15 at 10:03
Have a look at MoreLINQ's `DistinctBy`: https://github.com/morelinq/MoreLINQ/blob/master/MoreLinq/DistinctBy.cs — germi, Dec 07 '15 at 10:03
I am getting records with repeating AssessmentID. for example 255 (2 times) 3552( 4 times) , so in my list I want to pick two records one with assessmentID 255 and 2nd 3552 — K.Z, Dec 07 '15 at 10:05

Select Distinct record in LINQ Query

My Answer

0 Answers0