A
arj
Using dataset we can perform various database operations in
disconnected mode... but how to ensure database integrity?
Suppose person A is updating some 100 rows of a database using one web
application (dataset). Records were read and then loaded in the web
page. Meanwhile somebody else (person B) has updated 20 rows out of
those 100 rows. Then A submits his updates from the web page. What
will happen to those 20 rows? Whose changes will be there, A or B? How
does disconnected mode operation handles this situation? Is it totally
application's responsibility to ensure this kind of data integrity?
I have worked with datasets, but have never had a situation like this.
Any kind of help will be greatly appreciated.
Thanx,
Arj.
disconnected mode... but how to ensure database integrity?
Suppose person A is updating some 100 rows of a database using one web
application (dataset). Records were read and then loaded in the web
page. Meanwhile somebody else (person B) has updated 20 rows out of
those 100 rows. Then A submits his updates from the web page. What
will happen to those 20 rows? Whose changes will be there, A or B? How
does disconnected mode operation handles this situation? Is it totally
application's responsibility to ensure this kind of data integrity?
I have worked with datasets, but have never had a situation like this.
Any kind of help will be greatly appreciated.
Thanx,
Arj.