ADO.NET in a Nutshell

This enumeration is used to specify two properties of the ForeignKeyConstraint class: ForeignKeyConstraint.UpdateRule and ForeignKeyConstraint.DeleteRule . The value from this enumeration indicates what will happen to the related child rows when a change is made to a parent row. For example, by using a ForeignKeyConstraint.DeleteRule or Cascade , all child rows are removed when the parent row is deleted. If you use SetNull , the foreign key field in the child record is set to a null value. SetDefault restores the default value for the foreign key field; None performs no action .

public enum Rule { None = 0 , Cascade = 1 , SetNull = 2 , SetDefault = 3 }

Hierarchy

System.Object System.ValueType System.Enum(System.IComparable, System.IFormattable , System.IConvertible) Rule

Returned By

ForeignKeyConstraint.{DeleteRule , UpdateRule}

Passed To

ForeignKeyConstraint.{DeleteRule , ForeignKeyConstraint( ) , UpdateRule}