Though I am not a big fan, you can get the same behavior you
had in 2003 by
using your existing Typed DataSets (which your e-mail
implies but it is
clear that I am correct), and *completely* ignoring the
Table Adapters and
just use DataAdapters like you did in 2003.
Thanks,
Shawn Wildermuth
Wildermuth Consulting Services, LLC
http://adoguy.com
C# MVP, MCSD.NET, Author and Speaker
-----Original Message-----
From: Discussion of advanced .NET topics.
[mailto:ADVANCED-DOTNET DISCUSS.DEVELOP.COM] On Behalf Of Mark
Nicholls
Sent: Thursday, December 21, 2006 10:34 AM
To: ADVANCED-DOTNETDISCUSS.DEVELOP.COM
Subject: [ADVANCED-DOTNET] probably a naive question about
dataset
updates....
I've got a nice big dataset....under 2003 I had some code
derived from the
Microsoft code blocks, that did updates....inserts forwards,
deletes
backwards...so that FK constraints didn't get upset...all in
a
transaction.....lovely
now 2005....
so I'll just use the same code...
no...table adapters don't implement DataAdapter...yes I
believe I can go
into the designer and update the base class...but thats a
real pain, what
I like about datasets is that I can pick up the tables from
the explorer,
dump them on the designer and it writes the code....I don't
want to touch
that code...ever.
Now I could use the table adapters....but wont I get FK
constraint
problems if I don't do them in the correct order? (in fact
there isn't a
correct order...because the order for inserts is opposite to
that of
deletes).
P.S.
sometimes I think 2005 has stuff that is inferiour to
2003....bizarre.
===================================
This list is hosted by DevelopMentorŪ http://www.develop.com
View archives and manage your subscription(s) at http://discuss.develop.com
===================================
This list is hosted by DevelopMentorŪ http://www.develop.com
View archives and manage your subscription(s) at http://discuss.develop.com
|