private void UpdateIndexes(DatabaseTable table, IList <DatabaseIndex> indexes)
{
var tableIndexes = indexes.Where(x => x.SchemaOwner == table.SchemaOwner &&
x.TableName == table.Name);
foreach (var index in tableIndexes)
{
table.AddIndex(index);
}
}
private void UpdateIndexes(DatabaseTable table, IList <DatabaseIndex> indexes)
{
var tableIndexes = indexes.Where(x => x.SchemaOwner == table.SchemaOwner &&
x.TableName == table.Name);
foreach (var index in tableIndexes)
{
var list = new List <DatabaseColumn>();
foreach (var indexColumn in index.Columns)
{
var tableColumn = table.Columns.FirstOrDefault(c => c.Name == indexColumn.Name);
if (tableColumn != null)
{
list.Add(tableColumn);
}
}
index.Columns.Clear();
index.Columns.AddRange(list);
table.AddIndex(index);
}
}
