How to maintain database consistency

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

I have a database table which has a list of professor, from my website users can search and select a professor for a day.
As soon as a student select a professor I don't want that professor to be in the list of professors for other users and if that user doesn't confirm to go with this professor then again he should be displayed in the list.
Here is an example, I have four professors P1, P2,P3 and P4
All users can see all of them
now a user U1 select P2 so all other users should see P1,P3 and P4
Also, on next page if user U1 doesn't confirm then I have to add that P2 back to the list.
How can I achieve this in asp.net 4.0 with Sql server 2008

Posted 26-Mar-15 20:44pm

nikhil choudhry

Add a Solution

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)

F-ES Sitecore · Answer 1 · 2015-03-26T23:25:00

You haven't said what database access technology you're using so I'm just going to show you the raw SQL. If you are using something specific like ADO.net, LinqtoSQL, Entity Framework, NHibernate etc then you really should mention these things in your question as it often makes all the difference.

Add a bit\Boolean "locked" field to the Professor database and when you retrieve the professor

SQL

UPDATE Professor SET Locked = 1 WHERE ID = 123

SELECT * From Professor WHERE ID = 123

Then when the user chooses to not accept that professor to view

SQL

UPDATE Professor SET Locked = 0 WHERE ID = 123

You then update the sql that shows the list of available professors to exclude those that are locked

SQL

SELECT * From Professor WHERE Locked = 0