Database concurrency control question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Karl (Karl_at_discussions.microsoft.com)
Date: 01/28/05 

Date: Thu, 27 Jan 2005 21:17:07 -0800

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

Relevant Pages

  • Considering moving from Delphi to Python [Some questions]
    ... We program in Delphi in our shop and are generally very happy with it. ... We are now looking at cross-platform options especially for middle ... Middle tier in Python working as SOAP servers: ... want to do a lot of data entry forms including entry in grid like ...
    (comp.lang.python)
  • Re: Virtual keyboard
    ... Q Correll wrote: ... Tier one, two, three, or... ... looking at that kinda garbage I typed:) any more, ... Delphi things I have released: http://www.xcalibur.co.uk/DelphiThings ...
    (borland.public.delphi.thirdpartytools.general)
  • Delphi Socket Servers: If you were shown how, would you?
    ... With all the talk of other non-Delphi web server technologies floating ... Are there any Delphi Developers with web sites based on pure Delphi server ... And I bet I just forgot five other Delphi technologies out there... ...
    (borland.public.delphi.non-technical)
  • Re: Delphi Socket Servers: If you were shown how, would you?
    ... I don't understand why a Delphi Developer would feel the need to adopt a non-delphi web server technology platform if he/she already knew how to build a web server with Delphi... ...
    (borland.public.delphi.non-technical)
  • Re: Borlands linux strategy ?
    ... I don't care what server technology someone runs their ... So that's why FogBugz is delivered via a browser? ... even windows desktop development is no ... Delphi as a win tool provides the best solution because the universe of ...
    (borland.public.delphi.non-technical)