private void refreshTables()
{
var lst = TableWorkspaceList.GetTableWorkspaces(_generatorHelper);
gridTables.AutoGenerateColumns = false;
gridTables.DataSource = new BindingList <TableWorkspace>(lst.Workspaces.OrderBy(w => w.Table.ToString()).ToList());
}
private void refreshTables()
{
var lst = TableWorkspaceList.GetTableWorkspaces(_compareHelper, true, false);
TargetTable.Items.Clear();
TargetTable.Items.Add(string.Empty);
var toTbls = from s in _compareHelper.ToDataSource.CurrentDatabase.Schemas
from t in s.Tables
select t;
TargetTable.Items.AddRange(toTbls.OrderBy(t => t.TableName).ToArray());
gridTables.AutoGenerateColumns = false;
if (gridTables.DataSource != null)
{
var currws = (gridTables.DataSource as BindingList <TableWorkspace>).ToList();
foreach (var curr in currws)
{
var newws = lst.Workspaces.FirstOrDefault(ws => ws.SourceObject.ToString() == curr.SourceObject.ToString());
if (newws != null)
{
if (curr.Select)
{
newws.Select = curr.Select;
}
if (curr.SelectTableForData)
{
newws.SelectTableForData = curr.SelectTableForData;
}
if (curr.Delete)
{
newws.Delete = curr.Delete;
}
if (curr.KeepIdentity)
{
newws.KeepIdentity = curr.KeepIdentity;
}
if (curr.RemoveAddIndexes)
{
newws.RemoveAddIndexes = curr.RemoveAddIndexes;
}
if (curr.RemoveAddKeys)
{
newws.RemoveAddKeys = curr.RemoveAddKeys;
}
if (curr.Truncate)
{
newws.Truncate = curr.Truncate;
}
}
}
}
gridTables.DataSource = new BindingList <TableWorkspace>(
lst.Workspaces
.Where(ws => ws.TargetTable != null)
.OrderBy(w => w.SourceTable.ToString()).ToList());
}
private void refreshTables(List <DropWorkspace> dropWorkspaces)
{
var lst = TableWorkspaceList.GetTableWorkspaces(_compareHelper);
foreach (var dw in lst.DropWorkspaces)
{
dropWorkspaces.Add(dw);
}
TargetTable.Items.Clear();
TargetTable.Items.Add(string.Empty);
var toTbls = from s in _compareHelper.ToDatabase.Schemas
from t in s.Tables
select t;
TargetTable.Items.AddRange(toTbls.OrderBy(t => t.TableName).ToArray());
gridTables.AutoGenerateColumns = false;
gridTables.DataSource = new BindingList <TableWorkspace>(lst.Workspaces.OrderBy(w => w.SourceTable.ToString()).ToList());
}