private void UpdateColumnSize(IEnumerable <DBTable> tables, ConnectionProviderSql sqlDataStore) { foreach (var table in tables.Where(table => !HashSet.Contains(table.Name))) { HashSet.Add(table.Name); DBTable actualTable = null; foreach (var column in table.Columns.Where(col => col.ColumnType == DBColumnType.String)) { if (actualTable == null) { actualTable = new DBTable(table.Name); sqlDataStore.GetTableSchema(actualTable, false, false); } DBColumn dbColumn = column; var actualColumn = actualTable.Columns.Find(col => String.Compare(col.Name, sqlDataStore.ComposeSafeColumnName(dbColumn.Name), StringComparison.OrdinalIgnoreCase) == 0); if (NeedsAltering(column, actualColumn)) { if ((actualColumn.Size < column.Size) || (column.Size == SizeAttribute.Unlimited)) { var sql = GetSql(table, sqlDataStore, column); Trace.WriteLineIf(new TraceSwitch("XPO", "").TraceInfo, sql); sqlDataStore.ExecSql(new Query(sql)); } } } } }
private void UpdateColumnSize(IEnumerable <DBTable> tables, ConnectionProviderSql sqlDataStore) { foreach (var table in tables) { DBTable actualTable = null; foreach (var column in table.Columns.Where(col => col.ColumnType == DBColumnType.String)) { if (actualTable == null) { actualTable = new DBTable(table.Name); sqlDataStore.GetTableSchema(actualTable, false, false); } DBColumn dbColumn = column; var actualColumn = actualTable.Columns.Find(col => string.Compare(col.Name, sqlDataStore.ComposeSafeColumnName(dbColumn.Name), true) == 0); if (NeedsAltering(column, actualColumn)) { if ((actualColumn.Size < column.Size) || (column.Size == DevExpress.Xpo.SizeAttribute.Unlimited)) { var sql = GetSql(table, sqlDataStore, column); System.Diagnostics.Trace.WriteLineIf(new System.Diagnostics.TraceSwitch("XPO", "").TraceInfo, sql); sqlDataStore.ExecSql(new Query(sql)); } } } } }
private void UpdateColumnSize(IEnumerable<DBTable> tables, ConnectionProviderSql sqlDataStore) { foreach (var table in tables) { DBTable actualTable = null; foreach (var column in table.Columns.Where(col => col.ColumnType == DBColumnType.String)) { if (actualTable == null) { actualTable = new DBTable(table.Name); sqlDataStore.GetTableSchema(actualTable, false, false); } DBColumn dbColumn = column; var actualColumn = actualTable.Columns.Find(col => string.Compare(col.Name, sqlDataStore.ComposeSafeColumnName(dbColumn.Name), true) == 0); if (NeedsAltering(column, actualColumn)) { if ((actualColumn.Size < column.Size) || (column.Size == DevExpress.Xpo.SizeAttribute.Unlimited)) { var sql = GetSql(table, sqlDataStore, column); System.Diagnostics.Trace.WriteLineIf(new System.Diagnostics.TraceSwitch("XPO", "").TraceInfo, sql); sqlDataStore.ExecSql(new Query(sql)); } } } } }