private async Task _LoadDataTables()
{
Task[] loaders = new Task[] {
Task.Run(() => _versions = new VersionTable()),
Task.Run(() => _colors = new ColorTable()),
Task.Run(() => _items = new ItemTable()),
Task.Run(() => _recipes = new RecipeTable()),
Task.Run(() => _researchs = new ResearchTable()),
Task.Run(() => _schematics = new SchematicTable()),
};
await Task.WhenAll(loaders);
}
public List <SchematicTable> GetDataBaseSchema()
{
List <SchematicTable> _tables = new List <SchematicTable>();
using (SqlConnection connection = new SqlConnection(_configuration.ConnectionString))
{
connection.Open();
DataTable schemaTables = connection.GetSchema(CollectionNameOptions.Tables);
foreach (DataRow rowTable in schemaTables.Rows)
{
String tableName = rowTable.ItemArray[(int)TableSelectionIndex.Name].ToString();
SchematicTable currentTable = new SchematicTable(tableName);
string[] restrictionsColumns = new string[4];
restrictionsColumns[(int)RestrictionSelectionIndex.TableName] = tableName;
DataTable schemaColumns = connection.GetSchema(CollectionNameOptions.Columns, restrictionsColumns);
foreach (DataRow rowColumn in schemaColumns.Rows)
{
string ColumnName = rowColumn[(int)ColumnSelectionIndex.Name].ToString();
string ColumnType = rowColumn[(int)ColumnSelectionIndex.Type].ToString();
currentTable.Columns.Add(new Column()
{
Name = ColumnName, Type = ColumnType
});
}
string[] restrictionsPrimaryKey = new string[4];
restrictionsPrimaryKey[(int)RestrictionSelectionIndex.TableName] = tableName;
DataTable schemaPrimaryKey = connection.GetSchema(CollectionNameOptions.IndexColumns, restrictionsColumns);
foreach (DataRow rowPrimaryKey in schemaPrimaryKey.Rows)
{
string indexName = rowPrimaryKey[2].ToString();
if (indexName.IndexOf("PK_") != -1)
{
currentTable.PrimaryKey = new PrimaryKey()
{
FieldName = rowPrimaryKey[6].ToString(),
PrimaryKeyName = indexName
};
}
if (indexName.IndexOf("UQ_") != -1)
{
currentTable.UniqueKeys.Add(new UniqueKey()
{
FieldName = rowPrimaryKey[6].ToString(),
UniqueKeyName = indexName
});
}
}
string[] restrictionsForeignKeys = new string[4];
restrictionsForeignKeys[(int)RestrictionSelectionIndex.TableName] = tableName;
DataTable schemaForeignKeys = connection.GetSchema(CollectionNameOptions.ForeignKeys, restrictionsColumns);
foreach (DataRow rowFK in schemaForeignKeys.Rows)
{
var foreignName = rowFK[(int)ForeignKeySelectionIndex.Name].ToString();
var referencedTableName = rowFK[(int)ForeignKeySelectionIndex.ReferencedTableName].ToString();
currentTable.ForeignKeys.Add(new ForeignKey()
{
ForeignName = foreignName,
ReferencedTableName = referencedTableName
});
}
_tables.Add(currentTable);
}
}
return(_tables);
}