SessionStateSection.SqlConnectionString Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets or sets the SQL connection string.
public:
property System::String ^ SqlConnectionString { System::String ^ get(); void set(System::String ^ value); };[System.Configuration.ConfigurationProperty("sqlConnectionString", DefaultValue="data source=localhost;Integrated Security=SSPI")]
public string SqlConnectionString { get; set; }[<System.Configuration.ConfigurationProperty("sqlConnectionString", DefaultValue="data source=localhost;Integrated Security=SSPI")>]
member this.SqlConnectionString : string with get, setPublic Property SqlConnectionString As StringProperty Value
The SQL connection string. Its default value is the generic string: "data source=127.0.0.1;Integrated Security=SSPI"
- Attributes
Examples
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);
' Display the current SqlConnectionString property value.
Console.WriteLine("SqlConnectionString: {0}", _
sessionStateSection.SqlConnectionString)
Remarks
This sqlConnectionString attribute is required when Mode is set to SQLServer.
Note
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.
