Export (0) Print
Expand All

SessionStateSection.SqlConnectionString Property

Gets or sets the SQL connection string.

Namespace:  System.Web.Configuration
Assembly:  System.Web (in System.Web.dll)

[ConfigurationPropertyAttribute("sqlConnectionString", DefaultValue = "data source=localhost;Integrated Security=SSPI")]
public string SqlConnectionString { get; set; }

Property Value

Type: System.String
The SQL connection string. Its default value is the generic string: "data source=127.0.0.1;Integrated Security=SSPI"

This sqlConnectionString attribute is required when Mode is set to SQLServer.

NoteNote

To use the SQLServer session state mode, you must run the InstallSqlState.sql SQL script (which is installed in [drive:]\WINDOWS\Microsoft.NET\Framework\VersionNumber as part of the default .NET Framework installation) on the computer running SQL Server that will store the session state. This creates a database called ASPState with new stored procedures and creates new ASPStateTempApplications and ASPStateTempSessions tables in the TempDB database.

The following code example demonstrates how to get the SqlConnectionString property. Refer to the code example in the SessionStateSection class topic to learn how to access the SessionStateSection object.

// Display the current SqlConnectionString property value.
Console.WriteLine("SqlConnectionString: {0}",
  sessionStateSection.SqlConnectionString);

.NET Framework

Supported in: 4.5.2, 4.5.1, 4.5, 4, 3.5, 3.0, 2.0

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Show:
© 2014 Microsoft