Difference between "optimistic" and "pessimistic" locking, DOT NET Programming

Assignment Help:

What's difference between "Optimistic" and "Pessimistic" locking?

In the pessimistic locking when user wants to update a data it locks the record and till then no one can update data. The Other user's can only view the data when there is a pessimistic locking.

In the optimistic locking many users can open the same record for updating,and hence increases maximum concurrency. The Record is only locked when updating the record. This is the most preferred way of locking practically. In today's time the browser based application is very common and having the pessimistic locking is not a practical solution.


Related Discussions:- Difference between "optimistic" and "pessimistic" locking

We need long term kentico developer, We need Long term Kentico developer ne...

We need Long term Kentico developer needed I want a solid Kentico developer that I can rely on to handle overflow work. Usually this will include about 5 hours of work each week

ASP.NET, What is the Append Format for FileUpload Control in ASP.Net? What ...

What is the Append Format for FileUpload Control in ASP.Net? What it specify?

Wait handles, What are wait handles? The Wait handles sends signals of ...

What are wait handles? The Wait handles sends signals of a thread status from one thread to another thread. There are 3 kind of wait modes:- A)WaitOne. B)WaitAny. C)Wa

What is cyclomatic complexity and why is it important, What is cyclomatic c...

What is cyclomatic complexity and why is it important? Cyclomatic complexity is a computer science metric (measurement) developed by Thomas McCabe used to generally calculate t

What is plinq, What is PLINQ? PLINQ stands for Parallel Language Integr...

What is PLINQ? PLINQ stands for Parallel Language Integrated Query. It is the parallel execution of LINQ, in which a query can be implemented by using multiple processors. PLIN

It systems analyst, Project Description: Someone to review all our IT sy...

Project Description: Someone to review all our IT systems / dfs replication / set up/ backups etc and give a report. Skills required: SQL, Microsoft Exchange, Windows Serv

Ado.net architecture, Can you give an overview of ADO.NET architecture? ...

Can you give an overview of ADO.NET architecture? The most important part  in the ADO.NET architecture is the "Data Provider". The  Data Provider provides access to the datasou

Counting number of words in a string - c# program, Counting Number of Words...

Counting Number of Words in a String - C# Program Anyone can suggest me the output of the following program. using System;   class CountWords { public static void

We are seeking mobile game develope, Project Description: We are seeking...

Project Description: We are seeking Mobile game developer for long time our budget is per project Skills required: Mobile Phone, .NET

Add relation''s between table in a data set, How can we add relation's betw...

How can we add relation's between table in a DataSet? Dim objRelation As DataRelation  objRelation=New DataRelation("CustomerAddresses",objDataSet.Tables("Customer").Colu

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd