How to connect tables in entity framework and select properties by where condition?

Question

C++ / C#

I have a table Family and SubFamily. I enter the FamilyName field in the program and I want to get the names of the SubFamilyName based on this field. There is no FamilyName field in the SubFamilyName table, but the tables are related by ID.

Answer 1

Make connections

class SubFamily{
public int Id { get; set; }
public string Name { get; set; }
}

class Family{
public int Id { get; set; }
public string Name { get; set; }
public SubFamily SubFamily { get; set; }
}

family.SubFamily.Name