Cascading updates in SQL Server vs. typed Dataset

[Martin Rydman]

Hi!

The typed dataset supports cascading updates. SQL-server supports cascading
updates. I can drag tables from the server explorer (from a SQL-server
database
with FK constraints and cascading updates defined) on to a component
designer
and then generate a typed dataset. As far as I can tell, there's no way to
have the Typed Dataset Wizard create cascading updates (or FK constraints,
for that matter) automatically in the typed dataset. Am I right? (Obviously
I hope I'm wrong...)

If I'm right, can I turn my point of view 180 degrees, and use the dataset
designer (which supports both FK constraints and cascading updates) and use
the resulting schema to generate SQL-server tables, complete with
constraints
and cascades?

My whole aim here is to only have to update *one* structure (either
SQL-server
database structure or Dataset schema) and then have the other one
automatically
created for me.

Any hints appreciated!

TIA

/Martin

 

[Kevin Yu [MSFT]]

Hi Martin,

Based on my understanding, you would like to synchronize the changes
between Typed DataSet schema and database table structures. However, this
feature is not supported. Drag and drop the database table from the
solution explorer is just for convenience when creating the DataSet.
There's no relation between the Typed DataSet schema and database table
after the schema is created.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
--------------------
| From: "Martin Rydman" <[email protected]>
| Subject: Cascading updates in SQL Server vs. typed Dataset
| Date: Wed, 5 Nov 2003 09:06:24 +0100
| Lines: 37
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
| Message-ID: <#[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.adonet
| NNTP-Posting-Host: t1o63p36.telia.com 195.198.44.36
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:65464
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| Hi!
|
| The typed dataset supports cascading updates. SQL-server supports
cascading
| updates. I can drag tables from the server explorer (from a SQL-server
| database
| with FK constraints and cascading updates defined) on to a component
| designer
| and then generate a typed dataset. As far as I can tell, there's no way to
| have the Typed Dataset Wizard create cascading updates (or FK constraints,
| for that matter) automatically in the typed dataset. Am I right?
(Obviously
| I hope I'm wrong...)
|
| If I'm right, can I turn my point of view 180 degrees, and use the dataset
| designer (which supports both FK constraints and cascading updates) and
use
| the resulting schema to generate SQL-server tables, complete with
| constraints
| and cascades?
|
| My whole aim here is to only have to update *one* structure (either
| SQL-server
| database structure or Dataset schema) and then have the other one
| automatically
| created for me.
|
| Any hints appreciated!
|
| TIA
|
| /Martin
|
|
| --
| Martin Rydman
| Aprire AB
| (e-mail address removed)
|
|
|