Re: SQL Relations vs. DataRelations?

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

Date: Mon, 30 Aug 2004 16:51:10 -0700

Nope. It's not. ADO.NET has no mechanism to determine if tables are related
on the server. 

-- 
____________________________________
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:9F050416-7826-48FF-8C15-569BFD0706C3@microsoft.com...
> William,
>
> Thanks for the reply.  I guess my question is if I setup a relationship
> between two tables on the SQL Server side isn't it suppose to be reflected
> iwhen I drop the two tables onto my form and then generate the Dataset - 
> it
> shows the two tables and all the field member so why leave out the
> relationship?
>
> Peter
>
> "William (Bill) Vaughn" wrote:
>
>> 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
>>
>>
>>

Relevant Pages