Linq conditional query in C#

Question

I have the following two database tables. A group contains multiple members.

Groups: Id (int) | Name (int)

Members: Id (int) | GroupId (int) | IsExpert (bit)

I need to write a linq to sql query that returns the Groups that has no experts. Need some help

Kirk Broadhurst · Accepted Answer · 2010-10-09 00:39:23Z

1

Your answer should be those groups where the groups' collection of members doesn't contain any experts (ie !Any)

context.Groups.Where(group -> !group.Members.Any(member => member.IsExpert));

answered Oct 9, 2010 at 0:39

Kirk Broadhurst

28.9k20 gold badges111 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andrew Barber · Accepted Answer · 2010-10-09 00:25:01Z

0

var GroupsWithNoExperts =
DBDataContext.Groups.Where(
    g=>!DBDataContext.Members.Any(m=>m.GroupID==g.Id && m.IsExpert
));

answered Oct 9, 2010 at 0:25

Andrew Barber

40.3k20 gold badges97 silver badges124 bronze badges