Locking in Ado.Net

Question

3.00/5 (1 vote)

See more:

I have two applications that access the same database. The database is MySql. I want that when one application is updating a table then the second application cannot access that table.
How this can be done in Ado.net?

Posted 29-Aug-10 2:17am

Usama Aziz

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2010-08-29T03:01:00

Solution 1

Google for SQL lock...

Read this: Understanding Locking in SQL Server[^]

Posted 29-Aug-10 3:01am

Sandeep Mewara

Updated 29-Aug-10 3:02am

v2

Abhinav S · Answer 2 · 2010-08-29T03:32:00

Solution 2

See here[^] or here[^].

Posted 29-Aug-10 3:32am

Abhinav S

Usama Aziz · Answer 3 · 2010-08-29T04:50:00

Solution 3

but how do we implement these locks using ADO.NET?

Posted 29-Aug-10 4:50am

Usama Aziz

Comments

Sandeep Mewara 29-Aug-10 10:58am

1. Don't push answer button when actually it is a comment to an answer
2. You will put locks on columns in DB & queries you will use. Didn't you look at the links?

Usama Aziz 29-Aug-10 12:37pm

i look3at the links but i want to know how these can be implemented in through ado.net. basicaaly some sort of example code will be helpful

Lantei · Answer 4 · 2010-08-30T00:05:00

ok..it would be good if you did such a thing in the database itself but if you want to do things on the front-end level, then you'd have to do a bit of 'illegitimate' coding as I personally like to call it..and you can do so in these steps..

1. Instead of using a connected-environment, rather opt for a disconnected-environment (datasets)..

2. Now put every database action on a thread pool, so assign priorities to your threads ( so the action with the current connection has the highest priority etc), and then afterwards you can switch priorities after the action is completed to the next database action in the pool..

3. The multiple threads will create a sort of locking, but I must warn that this wont be something a programmer with less time on his hands ( and less programming knowledge would want to attempt)..

Its just an alternative course (thats why programmers are so diverse and gr8!)..but I would advice you to stick to doing it in the database..