How do I use a 'foreign key' as criteria in a LINQ to Entities query?

Question

I have a Departments table, which has a foreign key column to Sites, on Department.SiteId = Sites.SiteId. Now in my EF model, my Departments entity doesn't have a Siteid attribute, just a reference to Sites. How do I select, in a LINQ query, all departments with a specific SiteId?

Ben M · Accepted Answer · 2009-09-19 15:17:01Z

2

var query = from d in entities.Departments where d.Site.SiteId == theSiteId select d;

answered Sep 19, 2009 at 15:17

Ben M

22.6k3 gold badges69 silver badges71 bronze badges

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

1 Comment

ProfK Over a year ago

So simple, yet so elusive. Thanks! I was looking all over for SitesReference.EntityKey etc.

Collectives™ on Stack Overflow

How do I use a 'foreign key' as criteria in a LINQ to Entities query?

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related