CODEWITHSUNDEEP
c#linq-to-objectslinq
Shailesh Jaiswal
Shailesh Jaiswal

Reputation: 3654

How to use selectmany in linq?

The following is my linq query

  var meetingIndividualQuery = meetingsList.SelectMany(o => o.Attendies.Distinct().Where(x => x.CompanyId == company.CompanyId));

I have the following class

public class Meetings
    {
        public string IndustryCouncil { get; set; }
        public string MeetingType { get; set; }
        public string MeetingDescription { get; set; }
        public string MeetingDate { get; set; }
        public string MeetingHours { get; set; }
        public string MeetingHourlyValue { get; set; }
        public string MeetingTotal { get; set; }
        public List<Individual> Attendies { get; set; }
    }

With the above query I am getting the correct list of individaul but how I can I use the same query with the same condition to retrieve the list of Meetings. Can you please provide me any code

Upvotes: 0

Views: 2341

Answers (1)

Sergey Berezovskiy
Sergey Berezovskiy

Reputation: 236268

Following query will return list of meetings, which have at least one attendee with provided company id:

var query = meetingsList.Where(m => m.Attendies.Any(i => i.CompanyId == company.CompanyId));

You can also apply Distinct to Attendies before verifying Any

Upvotes: 2

Related Questions