kyaqub
June 10th, 2003, 09:11 AM
Greetings:
Well I have a question regarding Datasets. As we know the Datasets are use to manipulate the disconnected data. We can create a dataset in which we have as many tables with their schemas and relations. We can work on these tables having disconnected with the original datastore, and after a while we flush the changes back to the original datastore.
My question is about the Data Concurrency problems that arises by using the datasets. Suppose 2 users are working on the tables of our database, by having their own datasets for these tables at their specific machines. If User A delete a Row1 from the table author, & User B update the Row1 in the same, in their respective datasets, then when the users flush back the changes to the original datastore the data concurrency problem will arises and DBMS will generate some error or we r going to have some loss of data. So how to overcome this situation?
In previos versions of ADO we have the concept of Locking. So any locking concept is also present in ADO.Net??
What is the advantages & disadvantages of Datasets over their ancestors i.e. Recordsets.
Can anyone please explain.................
Regards
Kyaqub
Well I have a question regarding Datasets. As we know the Datasets are use to manipulate the disconnected data. We can create a dataset in which we have as many tables with their schemas and relations. We can work on these tables having disconnected with the original datastore, and after a while we flush the changes back to the original datastore.
My question is about the Data Concurrency problems that arises by using the datasets. Suppose 2 users are working on the tables of our database, by having their own datasets for these tables at their specific machines. If User A delete a Row1 from the table author, & User B update the Row1 in the same, in their respective datasets, then when the users flush back the changes to the original datastore the data concurrency problem will arises and DBMS will generate some error or we r going to have some loss of data. So how to overcome this situation?
In previos versions of ADO we have the concept of Locking. So any locking concept is also present in ADO.Net??
What is the advantages & disadvantages of Datasets over their ancestors i.e. Recordsets.
Can anyone please explain.................
Regards
Kyaqub