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