Constraint Class


The .NET API Reference documentation has a new home. Visit the .NET API Browser on to see the new experience.

Represents a constraint that can be enforced on one or more DataColumn objects.

Namespace:   System.Data
Assembly:  System.Data (in System.Data.dll)

public ref class Constraint abstract 


Initializes a new instance of the Constraint class.


This API supports the product infrastructure and is not intended to be used directly from your code. Gets the DataSet to which this constraint belongs.


The name of a constraint in the ConstraintCollection.


Gets the collection of user-defined constraint properties.


Gets the DataTable to which the constraint applies.


This API supports the product infrastructure and is not intended to be used directly from your code. Gets the DataSet to which this constraint belongs.


Determines whether the specified object is equal to the current object.(Inherited from Object.)


Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.(Inherited from Object.)


Serves as the default hash function. (Inherited from Object.)


Gets the Type of the current instance.(Inherited from Object.)


Creates a shallow copy of the current Object.(Inherited from Object.)


Sets the constraint's DataSet.


Gets the ConstraintName, if there is one, as a string.(Overrides Object::ToString().)

A constraint is a rule used to maintain the integrity of the data in the DataTable. For example, when you delete a value that is used in one or more related tables, a ForeignKeyConstraint determines whether the values in the related tables are also deleted, set to null values, set to default values, or whether no action occurs. A UniqueConstraint, on the other hand, just makes sure that all values within a particular table are unique. For more information, see DataTable Constraints.

A base Constraint constructor is not used. Primary or unique key constraints are created by using the UniqueConstraint constructor, and foreign key constraints are created by using the ForeignKeyConstraint constructor.

The following example examines the collection of constraints for a DataTable and determines whether each constraint is a UniqueConstraint or a ForeignKeyConstraint. The properties of the constraint are then displayed.

No code example is currently available or this language may not be supported.

.NET Framework
Available since 1.1

This type is safe for multithreaded read operations. You must synchronize any write operations.

Return to top