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:[EMAIL PROTECTED] On Behalf Of Mark Nicholls Sent: Thursday, December 21, 2006 10:34 AM To: ADVANCED-DOTNET@DISCUSS.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
