Sending a diffgram seems like it would be much cheaper than actually doing a round trip for every changed row, no?
Thanks, Shawn Wildermuth [EMAIL PROTECTED] > -----Original Message----- > From: dotnet discussion [mailto:[EMAIL PROTECTED]] > On Behalf Of Chris Anderson > Sent: Thursday, May 16, 2002 10:53 AM > To: [EMAIL PROTECTED] > Subject: Re: [DOTNET] ADO.NET multiple table updates > > > Thanks > > I am using three adapters, and an updating the parent first > (I have to update the parent first, to ensure integrity on > the database, and for new records, the foreign key(FK) isn't > known until the parent table has been written) > > The child tables do get updated with the FK once I call > Update on the parent table's adapter, but they are > immediately flagged as updated, so when it comes to using > their respective adapters to do their updates...nothing > occurs (the DataTable thinks it has already been updated) > > It occurs because I have the FKConstraints setup in the DataSet, ie > Dim fk As ForeignKeyConstraint > fk = New ForeignKeyConstraint("TypesFK", > dtSession.Columns("sessionid"), _ > dtTypes.Columns("sessionid")) > fk.UpdateRule = Rule.Cascade > fk.AcceptRejectRule = AcceptRejectRule.Cascade > dtInstitutionTypes.Constraints.Add(fk) > fk = Nothing > > If I remove them just before the parent table update, the > child tables are not flagged as written..but then they also > lose the automatic FK update when the parent table's ID is > set at the database > > I'm using SQL Server 2k, yes > I was thinking about using the GetXML, and passing that, then > using SQLXML to parse it server-side, but the diffgram could > potentially be large, so passing it via a SP parameter may > cause problems (Unless you are thinking of a different idea there) > > Merak > > > -----Original Message----- > > From: Shawn Wildermuth [mailto:[EMAIL PROTECTED]] > > Sent: 16 May 2002 15:21 > > To: [EMAIL PROTECTED] > > Subject: Re: [DOTNET] ADO.NET multiple table updates > > > > > > I have found that a separate DataAdapter for each table is > necessary > > and calling them in the right order is crucial in many > instances. It > > matters how your schema in the database (not the DataSet) > is expecting > > the data as to how you would call the updates. Are you > using one or > > three data adapters? If you are using SQL Server (2k?), maybe > > diffgrams are the better way to go if you can use SQLXML 3.0. > > > > Have I muddied the waters or clarified them? > > > > Thanks, > > > > Shawn Wildermuth > > [EMAIL PROTECTED] > > You can read messages from the DOTNET archive, unsubscribe > from DOTNET, or subscribe to other DevelopMentor lists at > http://discuss.develop.com. > You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
