Re: SQL Relations vs. DataRelations?

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 08/29/04 

Date: Sat, 28 Aug 2004 18:30:54 -0700

The relationships defined in a DataSet can be anything you choose--whether
or not they're reflected in the relationships on the server DBMS. You have
to define them yourself, however. 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Peter" <Peter@discussions.microsoft.com> wrote in message 
news:5BD10B9F-2986-4B96-8D70-10A0452816CA@microsoft.com...
> Hello,
>
> Thanks for reviewing my question.  I would like to know if I create a
> relationship via the SQL server's diagram is that replicated in the 
> Dataset's
> relations property?  It seems not to to be the case because if you look at
> the dataset via VS.NET editor, it only shows the two tables but no
> relationships.  If I create a relationship via SQL server and then I have 
> to
> create a relationship the dataset, this would be redundant.  Can you shed
> some light on this?
>
> Many Thanks
> Peter