SessionStateType SessionStateType SessionStateType SessionStateType Enum

Definition

Describes the session-state type used when installing a session-state database provider.

public enum class SessionStateType
public enum SessionStateType
type SessionStateType = 
Public Enum SessionStateType
Inheritance
SessionStateTypeSessionStateTypeSessionStateTypeSessionStateType

Fields

Custom Custom Custom Custom 2

Session-state data and stored procedures are placed in a custom data store.

Persisted Persisted Persisted Persisted 1

Session-state data and stored procedures are placed in the "ASPState" database. Session-state data will survive a restart of the database server.

Temporary Temporary Temporary Temporary 0

Session state data is stored in tempdb, and stored procedures are placed in the "ASPState" database. Session state data will not survive a restart of SQL Server.

Examples

The following code example shows how to use the SessionStateType enumeration with the InstallSessionState method of the SqlServices type.

// Install a custom session state database.
SqlServices.InstallSessionState(database,
    SessionStateType.Custom,
    connectionString);
' Install a custom session state database.
SqlServices.InstallSessionState(database, _
    SessionStateType.Custom, _
    connectionString)

Applies to

See also