如何在EF4实体上提取属性的数据库表和列名？

var objectContext = ((IObjectContextAdapter)dbContext).ObjectContext;
var metadataWorkspace = objectContext.MetadataWorkspace;
var entityMetadata = metadataWorkspace.GetItems<EntityType>(DataSpace.OSpace);

foreach (var entity in entityMetadata)
{
    // 获取表名
    var tableName = entity.MetadataProperties.FirstOrDefault(p => p.Name == "TableName").Value;

    // 获取列名
    var columnNames = entity.Properties.Select(p => p.Name);
}

public class EntityInfoAttribute : Attribute
{
    public string TableName { get; set; }
    public string ColumnName { get; set; }

    public EntityInfoAttribute(string tableName, string columnName)
    {
        TableName = tableName;
        ColumnName = columnName;
    }
}

public class User
{
    [EntityInfo("Users", "Id")]
    public int Id { get; set; }

    [EntityInfo("Users", "Name")]
    public string Name { get; set; }
}

var entity = new User();
var properties = entity.GetType().GetProperties();

foreach (var property in properties)
{
    var entityInfoAttribute = property.GetCustomAttribute<EntityInfoAttribute>();
    if (entityInfoAttribute != null)
    {
        var tableName = entityInfoAttribute.TableName;
        var columnName = entityInfoAttribute.ColumnName;
    }
}