Entity Framework filter on foreign key
Dep开发者_Go百科ot_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?
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);
精彩评论