PC Review


Reply
Thread Tools Rate Thread

CHECK constraint in .NET framework

 
 
Greg Allen
Guest
Posts: n/a
 
      18th Jul 2005
SQL Server provides a CHECK constraint to insure the data in a column
falls within a specified set of values. From SQL Server Books Online:

CHECK

Is a constraint that enforces domain integrity by limiting the possible
values that can be entered
into a column or columns.

How is this type of constraint implemented in the framework? Or is it? I
am trying
to get an accurate schema from my table, but this constraint doesn't appear
on the
generated .xsd file when I call WriteXmlSchema.

Thanks,

-- Greg





 
Reply With Quote
 
 
 
 
W.G. Ryan MVP
Guest
Posts: n/a
 
      18th Jul 2005
AFAIK there's no direct equivalent. However you can trap events of the
datatable and implement it on your own.. or even use ExtendedProperties to
do it.

HTH,

Bill
"Greg Allen" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> SQL Server provides a CHECK constraint to insure the data in a column
> falls within a specified set of values. From SQL Server Books Online:
>
> CHECK
>
> Is a constraint that enforces domain integrity by limiting the possible
> values that can be entered
> into a column or columns.
>
> How is this type of constraint implemented in the framework? Or is it? I
> am trying
> to get an accurate schema from my table, but this constraint doesn't
> appear on the
> generated .xsd file when I call WriteXmlSchema.
>
> Thanks,
>
> -- Greg
>
>
>
>
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
error evaluating check constraint - what does this mean? =?Utf-8?B?THlkaWE=?= Microsoft Access 5 15th Nov 2007 04:17 AM
CHECK constraint usage Jamie Collins Microsoft Access 10 25th Sep 2006 12:28 PM
Which CHECK constraint causes the exception? ferg Microsoft C# .NET 3 21st May 2006 09:38 PM
How to get Check constraint name with SQL =?Utf-8?B?QUEyZTcyRQ==?= Microsoft Access Database Table Design 1 6th Dec 2004 02:55 PM
Re: CHECK Constraint Michel Walsh Microsoft Access Forms 0 12th Mar 2004 12:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:48 PM.