Marshaling Disconnected Recordset Changes Back to the Business Layer

A Recordset without a live connection to a database server is called a disconnected Recordset. After the client machine receives the disconnected Recordset, it can use ADOR Recordset to manipulate data. After the changes are made to the Recordset, the client can choose to marshal the whole Recordset back or only the changed data. The MarshalOptions property of the ADO Recordset is designed for this purpose. You can set MarshalOptions to adMarshalAll, in which case all rows are returned to the server, or to adMarshalModified, which indicates that only modified rows are returned to the server. Setting the MarshalOptions property can improve performance when modified remote data is marshaled for updating back to the middle-tier or Web server.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


Recent Articles: