How do I clean up an SQL-Table on startup of ASP.Net project?

Question

0.00/5 (No votes)

See more:

Hey there.
So I have the following scenario:
Everytime a user logs in I write into a table with a field that displays whether there is an active session or not. When the user disconnects, it sets the field so that it says that the user is disconnected an the session is invalid. Now here's the obvious problem. When I shut the site down, the fields wont be set to invalid and on the next startup of the site, there are a bunch of invalid sessions. I could set them all to invalid manually but that's a rather sloppy solution. I was wondering if there's any mechanism I could use to set the fields initially to invalid on start of the asp.net site?

Thanks in advance.
Dennis

Posted 4-Apr-15 6:31am

Dennis Baberich

Add a Solution

Comments

PIEBALDconsult 4-Apr-15 12:34pm

What can the site do when you ask it to shut down?

Dennis Baberich 4-Apr-15 12:39pm

Doing something on shutdown is not a possible option. I want to make sure that if the server crashes ( just as an example ) everything will run well on next startup. Therefore I need to clean the tables on startup.

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)

Code For You · Accepted Answer · 2015-04-04T06:57:00

Solution 1

Use Aplication_start event from the global.asax file. You can write your custom logic here to cleanup the invalid sessions. This is the first event to called every time application starts.

Posted 4-Apr-15 6:57am

Code For You

Comments

Dennis Baberich 4-Apr-15 13:08pm

Perfect. I did not have the file but had no hassle adding it myself. Thank you very much.