But this is the way Microsoft implemented SqlDataAdapter in .NET 2.0 I've made the test presented in http://sourceforge.net/mailarchive/forum.php?thread_id=30866705&forum_id=12591 using SqlProvider and a similar SqlServer 2005 database. The test using SqlProvider works as i'm expected regarding Merge. I have studied why SqlDataAdapter works and FbDataAdapter do not. I discovered that SqlDataAdapter use it's base class (DbDataAdapter) implementation of protected virtual int Update(DataRow[] dataRows, DataTableMapping tableMapping) and there, if the command is an Insert they call row.AcceptChanges() before updating parameter values and returned row values and they call row.AcceptChanges() again after this update (as FbDataAdapter does). More, if AcceptChangesDuringUpdate is false they do not call row.AcceptChanges at all.
----- Original Message ----- From: "Carlos Guzmán Álvarez" <[EMAIL PROTECTED]> To: "For users and developers of the Firebird .NET providers" <[email protected]> Sent: Wednesday, November 08, 2006 3:58 PM Subject: Re: [Firebird-net-provider] FbDataAdapter problem > Hello: >> If command is an Insert FbDataAdapter should call row.AcceptChanges() >> before UpdateParameterValues > > The update method is implemented following the steps explained in the > microsoft docs, the > AcceptChanges call gets done as the last step and thats is not going to > change. > >> > > > -- > Carlos Guzmán Álvarez > Vigo-Spain > > http://carlosga.wordpress.com > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job > easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Firebird-net-provider mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
