private static void LoadAllTables()
{
for (int i = 0; i < singleTon.chkListTables.Items.Count; i++)
{
AllTables.CreateTableEntry(singleTon.chkListTables.Items[i].ToString());
}
foreach (TableName aTable in TablesAndViewsUI.AllTables.Tables)
{
aTable.ForeignKeys = singleTon.schemaLoader.LoadToList(FormatSQLParser.ForeignKeyQueryString(aTable.Name, FormatSQLParser.MSSQL_ForeignKeyQuery), _aDataObject);
aTable.PrimaryKeys = singleTon.schemaLoader.LoadToList(FormatSQLParser.PrimaryKeyQueryString(aTable.Name, FormatSQLParser.MSSQL_PrimaryKeyQuery), "ColumnName", _aDataObject);
aTable.AlternativeKeys = singleTon.schemaLoader.LoadToList(SchemaRestrictions.Columns, aTable.Name, "COLUMN_NAME", _aDataObject);
}
}
public static void PrepareTable(TableName aTable)
{
aTable.ForeignKeys = singleTon.schemaLoader.LoadToList(FormatSQLParser.ForeignKeyQueryString(aTable.Name, FormatSQLParser.MSSQL_ForeignKeyQuery), _aDataObject);
aTable.PrimaryKeys = singleTon.schemaLoader.LoadToList(FormatSQLParser.PrimaryKeyQueryString(aTable.Name, FormatSQLParser.MSSQL_PrimaryKeyQuery), "ColumnName", _aDataObject);
aTable.AlternativeKeys = singleTon.schemaLoader.LoadToList(SchemaRestrictions.Columns, aTable.Name, "COLUMN_NAME", _aDataObject);
}
