Entity Framework filter on foreign key

Question

Depot_ID is a foreign key in the database table Address. In my entity model i noticed that the foreign keys are not listed in the diagram

var Address = db.ADDRESS.Where(a => a.Depot_ID == id.Value);

This does not work as Depot_id is a foreign key in the Address table. What do I need to do to filter on this field?

Answer 1

You reference the ID via the navigation property. You don't say what your class properties are named, but the general idea is:

var Address = db.ADDRESS.Where(a => a.Depot.Depot_ID == id.Value);