Re: ADO and ADO.net

Tech-Archive recommends: Fix windows errors by optimizing your registry

What is pessimistic and optimistic concurrency ?

Rgds
Daniel



Cor Ligthert [MVP] wrote:
Daniel,

Whats the differences of ADO and ADO.net ? Which one should i use if i
need to design application that using SQL server ? Thanks

The differences are the same as between a car and a plane, however they are
both for transport.

However for your design is probably only important that ADO is mostly done
with pessimistic concurrency and ADONET in my opinion only is good posible
with optimistic concurrency.

I hope that this gives an idea.

Cor

.

Relevant Pages

  • Re: Is this correct OO design?
    ... This is NOT bad design. ... look at the timestamp data type in SQL Server, and Optimistic Concurrency ... > (OriginalArticle) WITHIN THE CLASS ITSELF? ... > public static void GetArticleData ...
    (microsoft.public.dotnet.general)
  • Re: ADO and ADO.net
    ... But which is suitable if i just need to design simple ... Cor Ligthert [MVP] wrote: ... need to design application that using SQL server? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Optimistic Concurrency - how? - net 2.0
    ... How does SQL Server implement optimistic concurrency in a way that helps ... How does normalization prevent 2 users from editing the same row at the same ... Means, I can check and see that a concurrency violation is present, ...
    (microsoft.public.dotnet.framework.adonet)