intermittent database connection

Question

0.00/5 (No votes)

See more:

SQL-Server-2014

hi i have a c# program that 2 user in network can use it (database is in my computer)
in sql server i follow this way --->right click on database --->properties--->option-- restict access-->
and choice : Single_User . it means one user in a time can access to data base .
now :
1- what happend if another user try to access to this database in same time ?
2- in this case i dont want my program show eror or any thing else ! i want user no2 automaticaly wait till user no1 close then databas and make it free !
how can i do it in c sharp ?!

Posted 1-Feb-15 3:49am

itman2

Add a Solution

Comments

Tomas Takac 1-Feb-15 10:28am

Why would you do such thing? Single user mode is for maintenance, not for normal operations.

itman2 1-Feb-15 10:56am

it is a sales program . for example we have 3pen for sale .
user1 want to sale 2 pen and in same time user2 want to sale 2 pen too .
what is you solution for this case ?

PIEBALDconsult 1-Feb-15 10:38am

After all the work that thousands of very smart people put in to make concurrent access feasible you're goint to try to undo it?

1 solution

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)

Tomas Takac · Answer 1 · 2015-02-01T07:01:00

Look for optimistic concurrency. I'm sure there is support for this scenario in majority of data access technologies out there, e.g.:

Generally you compare the data that you have loaded in your app to the data in your database just before the update. In your example of buying pens this would go something like this:

SQL

update stock_table
set amount = @new_amount
where id = @pen_id 
and amount = @old_amount

if @@ROWCOUNT = 0 RAISERROR(...)

This way you can be sure that nobody else update the row in the meantime. Or you can use a dedicated version column. But you definitely need to do some reading first.