why are foreign key constraints not enforced?

[assaf]

hi all

a am developing an application.
i am using C# on visual studio 2005 beta 2.

all is fine...
except that foreign key constraints are not being enforced at all.

i am easily able to add a value in a table, where i have a foreign key
constraint set.
the value i am feeding is one of a record that simply does not exist!!


has anyone experienced this problem?
plz hlp me...

assaf

 

[Guest]

I don't suppose you've set EnforceConstraints = true?

http://msdn.microsoft.com/library/d...emdatadatasetclassenforceconstraintstopic.asp

 

[W.G. Ryan MVP]

Are you talking about a DataTable or a Database's table? I'm using it right
now and not having any such problems. Can you post some code w/ a few more
details - probably be a lot easier to diagnose that way ;-)

Thanks,

Bill