private void AddConstraints(DataSet ds, DatabaseTable table)
{
if (ds.Tables.Contains(_schemaReader.PrimaryKeysCollectionName))
{
var converter = new SchemaConstraintConverter(ds.Tables[_schemaReader.PrimaryKeysCollectionName],
ConstraintType.PrimaryKey);
var pkConstraints = converter.Constraints();
PrimaryKeyLogic.AddPrimaryKey(table, pkConstraints);
}
if (ds.Tables.Contains(_schemaReader.ForeignKeysCollectionName))
{
var converter = new SchemaConstraintConverter(ds.Tables[_schemaReader.ForeignKeysCollectionName],
ConstraintType.ForeignKey);
table.AddConstraints(converter.Constraints());
}
if (ds.Tables.Contains(_schemaReader.ForeignKeyColumnsCollectionName))
{
var fkConverter = new ForeignKeyColumnConverter(ds.Tables[_schemaReader.ForeignKeyColumnsCollectionName]);
fkConverter.AddForeignKeyColumns(table.ForeignKeys);
}
if (ds.Tables.Contains(_schemaReader.UniqueKeysCollectionName))
{
var converter = new SchemaConstraintConverter(ds.Tables[_schemaReader.UniqueKeysCollectionName],
ConstraintType.UniqueKey);
table.AddConstraints(converter.Constraints());
}
}
private void UpdateCheckConstraints(DatabaseTable table, IList <DatabaseConstraint> constraints)
{
var checks = constraints.Where(x => x.SchemaOwner == table.SchemaOwner &&
x.TableName == table.Name);
table.AddConstraints(checks);
}
private void UpdateConstraints(DatabaseTable table, IList <DatabaseConstraint> constraints, ConstraintType constraintType)
{
var keys = constraints.Where(x => x.SchemaOwner == table.SchemaOwner &&
x.TableName == table.Name &&
x.ConstraintType == constraintType);
table.AddConstraints(keys);
}
