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));
}
}
}
}
}