Data Concurrency Control In Ado.net

Data access technology develops from connection model to disconnection model in the database system。The advantage of the disconnect data access model technology is to make serializable concurrency control protocol possible, which differs from the traditional one , In anatomy of ADO.NET, a timestamp validation-base two-phase locking multi version protocol is presented. The protocol resolves concurrent-access anomalies under the disconnection data access model ,ensures data consistency and improve performance and concurrency degree.DataSet as a symbol of ADO.NET object model ,it is not connected the data source to provide the services。It reduce the high cost of access the database and improve performance, but it also bring a number of problems. As if a user attempts to access the same data at the same time。Now ADO.NET through optimistic concurrency approach to solution the problems。This article describle the principle of the method。This program is using the .NET platform, It using some features of ADO.NET to control the concurrency of ADO.NET, The program of design try catch and transaction features to increase the Data concurrency。...