ASP State management in SQL server

Question

0.00/5 (No votes)

See more:

I am trying to manage my session in SQL state but ..
I have a query does this Db ASP State create Tables So that i can check its contain ..

How can i know that whether its working or not???

Posted 6-Feb-12 21:22pm

Vishal Waman

Updated 6-Feb-12 21:28pm

Herman<T>.Instance

v2

Add a Solution

Comments

Herman<T>.Instance 7-Feb-12 3:38am

in the connectionstring you state your database name. In management studio you should be able to see what is in there!

2 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)

Varun Sareen · Answer 1 · 2012-02-06T21:52:00

Solution 1

Dear Friend,

Yes it creates table named as ASPStateTempSessions which is created by aspnet_regsql.
Yes you can fetch data from thsi table. Please follow link:-

http://msdn.microsoft.com/en-us/library/aa478952.aspx[^]

I hope this will help you out.

Thanks

Posted 6-Feb-12 21:52pm

Varun Sareen

v2

Rakesh Meel · Answer 2 · 2012-02-06T21:56:00

public abstract class SessionStateStoreProviderBase : ProviderBase
{
public abstract void Dispose();

public abstract bool SetItemExpireCallback
(SessionStateItemExpireCallback expireCallback);

public abstract void InitializeRequest(HttpContext context);

public abstract SessionStateStoreData GetItem
(HttpContext context, String id, out bool locked,
out TimeSpan lockAge, out object lockId,
out SessionStateActions actions);

public abstract SessionStateStoreData GetItemExclusive
(HttpContext context, String id, out bool locked,
out TimeSpan lockAge, out object lockId,
out SessionStateActions actions);

public abstract void ReleaseItemExclusive(HttpContext context,
String id, object lockId);

public abstract void SetAndReleaseItemExclusive
(HttpContext context, String id, SessionStateStoreData item,
object lockId, bool newItem);

public abstract void RemoveItem(HttpContext context,
String id, object lockId, SessionStateStoreData item);

public abstract void ResetItemTimeout(HttpContext context,
String id);

public abstract SessionStateStoreData CreateNewStoreData
(HttpContext context, int timeout);

public abstract void CreateUninitializedItem
(HttpContext context, String id, int timeout);

public abstract void EndRequest(HttpContext context);
}