@Doug : One helpful advise before you try to save whole Dataset full of interrelated tables (with many foreign key constraints) ,
If you try to save it using cascade-update-delete and get transaction error from deep within generated table adapter code , try disabling the constraint before saving because it might issue constraint failure due to nested table constraints. Also I have seen VS generated table adapter code to hang while committing the transaction due to nested table constraints. After a lot of debugging I found it tries to sort the constraints according to hierarchy , for example Dataset with tables having more than 2-3 foreign key constraints repeatedly hanged in that sorting loop. Still could not find any good solution to that problem , I had to manually patch the code :( In the end, it all depends on you Dataset schema and relations. Wish you good luck. On Feb 24, 9:43 am, Arsalan Tamiz <[email protected]> wrote: > http://blogs.msdn.com/bethmassi/archive/2007/07/11/tableadapters-and-... > > On Feb 24, 2:04 am, "Charles A. Lopez" <[email protected]> > wrote: > > > I've been away. Can someone identify the source of the 3-tier model? I'd > > love to read on the standard. Perhaps on wiki? > > > On 11/14/07, Michael O'Neill <[email protected]> wrote: > > > > A stored procedure. > > > > On Nov 14, 4:24 am, Doug <[email protected] > wrote: > > > > Hi group, > > > > I've written a 3-tier solution in C#, making use of an .xsd dataset as > > > > part of the data layer. > > > > What is the best method to implement an SQL transaction, from the data > > > > layer, when inserting a parent and child record? > > > > P.S. Charles, please don't ask him to explain 3-tier...(sigh) > > > > --~--~---------~--~----~------------~-------~--~----~ > > > You received this message because you are subscribed to the Google Groups > > > "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web > > > Services,.NET Remoting" group. > > > To post to this group, send email to [email protected] > > > To unsubscribe from this group, send email to > > > [email protected] > > > For more options, visit this group at > > >http://cm.megasolutions.net/forums/default.aspx > > > -~----------~----~----~----~------~----~------~--~--- > > > -- > > Charles A. Lopez > > [email protected] > > > Start your career with Charles A. Lopez TECHNOLOGY - Send your resume > > to [email protected] > > >http://cs.nyu.edu/web/People/alumni.html
