Hi .NET experts,
I was a 2 tier database programmer using delphi. In Delphi, if user A is
writting a record, this record is locked from user B for writting. If user A
insert a new record, when user B moves cursor in datagrid, the new record
will be reflected in the applicatoin.
In ADO.NET, we use a 3-tier like logic. Dataset is the middle tier to me.
After data is filled in dataset, dataset is not aware of the change in SQL
Server. So when user A edits a new record in his dataset in his local
machine, user B might be doing the same thing. When they update SQL Server,
no gurrentee the accuracy. When User A creates a record and insert it in SQL
server, user B is not aware about it. He might be doing the samething. So it
might end up with the duplicate record information.
Even with the connected layer of ADO.NET, it does not have real time
concurrecny control like I had in old delphi 2 tier system.
I am new to C#. So I might miss some wonderful features of .NET. Could
someone tell me how to get the real time concurrency control in .NET like I
had before in delphi?
Thanks,
Karl