Constraints

System\Data\Constraint.cs (2)

47Table.Constraints.RegisterName(value); 49Table.Constraints.UnregisterName(_name);

System\Data\ConstraintCollection.cs (2)

120UniqueConstraint? key = fk.RelatedTable.Constraints.FindKeyConstraint(fk.RelatedColumnsReference); 129fk.RelatedTable.Constraints.Add(key);

System\Data\ConstraintEnumerator.cs (1)

37_constraints = ((DataTable)_tables.Current).Constraints.GetEnumerator();

System\Data\DataColumn.cs (13)

742for (int i = 0; i < _table.Constraints.Count; i++) 744if (_table.Constraints[i].ContainsColumn(this)) 746throw ExceptionBuilder.ExpressionAndConstraint(this, _table.Constraints[i]); 1018UniqueConstraint? key = _table!.Constraints.FindKeyConstraint(this); 1021_table.Constraints.Remove(key); 1040_table!.Constraints.Add(key); 1109UniqueConstraint? constraint = table!.Constraints.FindKeyConstraint(this); 1112table.Constraints.CanRemove(constraint, true); 1233for (IEnumerator e = _table.Constraints.GetEnumerator(); e.MoveNext();) 1240_table.Constraints.CanRemove(oldConstraint, true); 1254Debug.Assert(_table.Constraints.FindKeyConstraint(this) == null, "Should not be a duplication constraint in collection"); 1255_table.Constraints.Add(constraint); 1259_table.Constraints.Remove(oldConstraint!);

System\Data\DataColumnCollection.cs (4)

511for (int i = 0; i < _table.Constraints.Count; i++) 513if (_table.Constraints[i].ContainsColumn(column)) 517throw ExceptionBuilder.CannotRemoveConstraint(_table.Constraints[i].ConstraintName, _table.Constraints[i].Table!.TableName);

System\Data\DataRelation.cs (2)

486ForeignKeyConstraint? constraint = ChildTable.Constraints.FindForeignKeyConstraint(ChildKey.ColumnsReference, ParentKey.ColumnsReference); 791foreach (Constraint cs in ChildTable.Constraints)

System\Data\DataRelationCollection.cs (3)

806ForeignKeyConstraint? foreignKey = relation.ChildTable.Constraints.FindForeignKeyConstraint(relation.ParentColumnsReference, relation.ChildColumnsReference); 811relation.ChildTable.Constraints.Add(foreignKey = new ForeignKeyConstraint(relation.ParentColumnsReference, relation.ChildColumnsReference)); 824UniqueConstraint? key = relation.ParentTable.Constraints.FindKeyConstraint(relation.ParentColumnsReference);

System\Data\DataSet.cs (6)

1093Tables[i].Constraints.FinishInitConstraints(); 1172ConstraintCollection constraints = tbls[i].Constraints; 1186ds.Tables[i].Constraints.Add(constraints[j].Clone(ds)!); 3237ConstraintCollection cons = Tables[i].Constraints; 3280constraints = Tables[i].Constraints; 3320constraints = Tables[i].Constraints;

System\Data\DataTable.cs (31)

524for (int i = 0; i < Constraints.Count; i++) 526Constraint c = Constraints[i]; 615Constraints.Add(uc); 652Constraints.Add(fk, false); 1071foreach (Constraint constraint in Constraints) 1202/// Resets the <see cref='System.Data.DataTable.Constraints'/> property to its default state. 1204private void ResetConstraints() => Constraints.Clear(); 1322foreach (Constraint constr in Constraints) 1490foreach (Constraint constraint in Constraints) 1686if ((existingKey = (UniqueConstraint?)Constraints.FindConstraint(key)) != null) 1714Constraints.Remove(oldKey); 1720Constraints.Add(key); 1725Debug.Assert(_primaryKey == null || Constraints.FindConstraint(_primaryKey) == _primaryKey, "PrimaryKey is not in ConstraintCollection"); 2029Constraints.FinishInitConstraints(); 2449for (int j = 0; j < Constraints.Count; j++) 2451ForeignKeyConstraint? foreign = Constraints[j] as ForeignKeyConstraint; 2452UniqueConstraint? unique = Constraints[j] as UniqueConstraint; 2458clone.Constraints.FindConstraint(clonedConstraint) is Constraint oldConstraint) 2460oldConstraint.ConstraintName = Constraints[j].ConstraintName; 2467clone.Constraints.FindConstraint(clonedConstraint) is Constraint oldConstraint) 2469oldConstraint.ConstraintName = Constraints[j].ConstraintName; 2479for (int j = 0; j < Constraints.Count; j++) 2481if (!clone.Constraints.Contains(Constraints[j].ConstraintName, true)) 2483ForeignKeyConstraint? foreign = Constraints[j] as ForeignKeyConstraint; 2484UniqueConstraint? unique = Constraints[j] as UniqueConstraint; 2491clone.Constraints.Add(newforeign); 2496clone.Constraints.Add(unique.Clone(clone)!); 6558foreach (Constraint tempConstrain in sourceTable.Constraints) 6568if (!destinationTable.Constraints.Contains(newFKC.ConstraintName)) 6570destinationTable.Constraints.Add(newFKC); // we know that the dest table is already in the table

System\Data\Merger.cs (5)

472for (int i = 0; i < table.Constraints.Count; i++) 474Constraint src = table.Constraints[i]; 486Constraint? cons = dest.Table!.Constraints.FindConstraint(dest); 494dest.Table.Constraints.Add(dest); 500dest.Table.Constraints.Add(dest);

System\Data\ProviderBase\SchemaMapping.cs (1)

1088ConstraintCollection constraints = _dataTable.Constraints;

System\Data\xmlsaver.cs (5)

286foreach (Constraint constr in table.Constraints) 439foreach (Constraint cs in dt.Constraints) 453UniqueConstraint? _constraint = (UniqueConstraint?)fk.RelatedTable.Constraints.FindConstraint(new UniqueConstraint("TEMP", fk.RelatedColumnsReference)); 1977ConstraintCollection constraints = table.Constraints; 2077UniqueConstraint? _constraint = (UniqueConstraint?)foreign.RelatedTable.Constraints.FindConstraint(new UniqueConstraint("TEMP", fields));

System\Data\XMLSchema.cs (6)

1307int iExisting = fKey[0].Table!.Constraints.InternalIndexOf(name); 1310if (fKey[0].Table!.Constraints[iExisting].ConstraintName != name) 1317fKey[0].Table!.Constraints.Add(fkc); 1412UniqueConstraint? found = (UniqueConstraint?)key[0].Table!.Constraints.FindConstraint(new UniqueConstraint(name, key)); 1416key[0].Table!.Constraints.Add(name, key, fPrimaryKey); 1417SetExtProperties(key[0].Table!.Constraints[name]!, keyNode.UnhandledAttributes);