SQL Server中的ASP状态管理 [英] ASP State management in SQL server

问题描述

我正在尝试以SQL状态管理会话，但是..
我有一个查询是否可以为此DB ASP状态创建表，以便我可以检查其包含..

我怎么知道它是否起作用?

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???

推荐答案

亲爱的朋友，

是的，它将创建一个名为 ASPStateTempSessions 的表，该表是由aspnet_regsql创建的.
是的，您可以从该表中获取数据.请点击链接:-

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

希望对您有所帮助.

谢谢

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

公共抽象类SessionStateStoreProviderBase:ProviderBase
{
公共抽象void Dispose();

公共抽象bool SetItemExpireCallback
(SessionStateItemExpireCallback expireCallback);

公共抽象无效InitializeRequest(HttpContext context);

公共抽象SessionStateStoreData GetItem
(HttpContext上下文，字符串ID，输出锁定，
out TimeSpan lockAge，out对象lockId，
out SessionStateActions操作)；

公共抽象SessionStateStoreData GetItemExclusive
(HttpContext上下文，字符串ID，输出锁定，
out TimeSpan lockAge，out对象lockId，
out SessionStateActions操作)；

公共抽象无效ReleaseItemExclusive(HttpContext上下文，
字符串ID，对象lockId);

公共抽象无效SetAndReleaseItemExclusive
(HttpContext上下文，字符串ID，SessionStateStoreData项，
object lockId，bool newItem);

公共抽象无效RemoveItem(HttpContext上下文，
字符串ID，对象lockId，SessionStateStoreData项目);

公共抽象无效ResetItemTimeout(HttpContext上下文，
字符串ID);

公共抽象SessionStateStoreData CreateNewStoreData
(HttpContext上下文，int超时)；

公共抽象无效CreateUninitializedItem
(HttpContext上下文，字符串id，int超时)；

公共抽象无效EndRequest(HttpContext context);
}

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);
}

这篇关于SQL Server中的ASP状态管理的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！