/// <summary>
///
/// </summary>
/// <returns></returns>
public override List <TableInfo> GetTableInfos()
{
SqlTableManager.InitializeTables();
SqlColumnManager.InitializeColumns();
SqlUniqueKeyManager.InitializeUniqueKeys();
SqlPrimaryKeyManager.InitializePrimaryKeys();
SqlForeignKeyManager.InitializeForeignKeys();
var sqlTables = SqlTableManager.GetTables();
_tableInfos = sqlTables.Select(ConvertToTableInfo).ToList();
_tableInfos.ForEach(FillForeignKeyInfos);
return(_tableInfos);
}
/// <summary>
///
/// </summary>
/// <param name="table"></param>
/// <param name="sqlTable"></param>
/// <returns></returns>
private PrimaryKeyInfo GetPrimaryKeyInfo(TableInfo table, SqlTable sqlTable)
{
var sqlPrimaryKey = SqlPrimaryKeyManager.GetPrimaryKey(sqlTable);
if (sqlPrimaryKey == null)
{
return(null);
}
var primaryKey = new PrimaryKeyInfo();
primaryKey.Name = sqlPrimaryKey.ConstraintName;
primaryKey.Table = table;
primaryKey.PrimaryColumn = table.GetColumn(sqlPrimaryKey.ColumnName);
return(primaryKey);
}