使用Entity Framework 4以编程方式读取外键元数据

public class MyDbContext : DbContext
{
    public DbSet<Table1> Table1 { get; set; }
    public DbSet<Table2> Table2 { get; set; }
}

public class Table1
{
    public int Id { get; set; }
    public string Name { get; set; }
    public int Table2Id { get; set; }
    public Table2 Table2 { get; set; }
}

public class Table2
{
    public int Id { get; set; }
    public string Name { get; set; }
    public ICollection<Table1> Table1s { get; set; }
}

using (var context = new MyDbContext())
{
    var table1 = context.Table1.First();
    var foreignKey = context.Entry(table1).Metadata.GetForeignKeys().FirstOrDefault();
    if (foreignKey != null)
    {
        var foreignKeyName = foreignKey.Properties.FirstOrDefault()?.Name;
        var referencedTableName = foreignKey.PrincipalEntityType.Name;
        var referencedColumnName = foreignKey.PrincipalKey.Properties.FirstOrDefault()?.Name;

        // 在这里可以使用外键元数据进行进一步的操作
    }
}