entity framework / linq query construction

Question

I have the following tables:

Project:

Id
SettlementId
...

Settlement

Id
Name
AreaId

Area

Id
Name
...

I need to get all settlements that belong to a particular area (i get the areaId from the selected dropdownlist) that are not part of any project.

So far this is my query:

var settlements = (from s in entities.Settlements
                  where s.AreaId == selectedAreaId
                  select s).toList();

Am not entirely sure how to filter out the settlements that are already part of an existing project.

Thanks for your time!

Johann Blais · Accepted Answer · 2012-12-11 19:43:46Z

1

Did you try?

where s.Projects.Count() == 0

answered Dec 11, 2012 at 19:43

Johann Blais

9,4596 gold badges50 silver badges66 bronze badges

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

2 Comments

Dragan Over a year ago

hah that worked.. I'm new to C# and I never knew about the fact that I get an ICollection property after i declare a 1 -> * rel. Thanks heaps! Will accept your answer as correct after 5 mins

Liz Over a year ago

Even better, !s.Projects.Any(); Count always iterates the collection, but Any just returns true if it finds something. It's a minor improvement, but there's no reason not to do it.

Collectives™ on Stack Overflow

entity framework / linq query construction

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related