public void ExtractMetadata(SchemaModel model, string databaseName) { FDatabase = model.CreateDatabase(databaseName); using (MySqlConnection OConnection = new MySqlConnection(FConnStr)) { using (MySqlCommand OCommand = new MySqlCommand(ExtractSchemaSql, OConnection)) { OConnection.Open(); using (IDataReader OReader = OCommand.ExecuteReader()) { while (OReader.Read()) { Table OTable = GetTableData(model, OReader); AddColumnData(OTable, OReader); } } } } }
public void ExtractMetadata(SchemaModel model, string databaseName) { FDatabase = model.CreateDatabase(databaseName); using (SqlConnection OConnection = new SqlConnection(FConnStr)) { using (SqlCommand OCommand = new SqlCommand(ExtractSchemaSql, OConnection)) { Debug.WriteLine("Extracting database schema info"); OConnection.QuickOpen(OConnection.ConnectionTimeout); using (IDataReader OReader = OCommand.ExecuteReader()) { while (OReader.Read()) { Table OTable = GetTableData(model, OReader); AddColumnData(OTable, OReader); } } } } }
public void ExtractMetadata(SchemaModel model) { FModel = model; //Needs restructuring FDatabase = FModel.CreateDatabase(FDatabaseName); using (SqlConnection OConnection = new SqlConnection(FConnStr)) { using (SqlCommand OCommand = new SqlCommand(ExtractSchemaSql, OConnection)) { OConnection.Open(); using (IDataReader OReader = OCommand.ExecuteReader()) { while (OReader.Read()) { Table OTable = GetTableData(OReader); AddColumnData(OTable, OReader); } } } } }