How you will set the datarelation between two columns?
Answer Posted / swapna
ADO.NET provides DataRelation object to set relation
between two columns.It helps to enforce the following
constraints,a unique constraint, which guarantees that a
column in the table contains no duplicates and a foreign-
key constraint,which can be used to maintain referential
integrity.
A unique constraint is implemented either by simply setting
the Unique property of a data column to true, or by adding
an instance of the UniqueConstraint class to the
DataRelation object's ParentKeyConstraint.
As part of the foreign-key constraint, you can specify
referential integrity rules that are applied at three
points,when a parent record is updated,when a parent record
is deleted and when a change is accepted or rejected.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is namespace in ado.net?
What are the methods of XML dataset object?
Describe the command object and its method.
What are the drawbacks of using ado.net?
Explain the difference between ado and ado.net?
What is dbcontext and dbset in entity framework?
Does sqlclient and oledb class share the same functionality?
Define Execute Scalar?
Define atomicity?
How can we check that some changes have been made to dataset since it was loaded?
What is ado recordset?
What is ado net stands for?
What are the benefits of ADO.NET?
Why do we serialize data?
What does ado stand for in ado.net?