SqlConnectionStringBuilder.UserInstance Property (System.Data.SqlClient)

UserInstance Property

Switch on low bandwidth view

Collapse All

Language Filter

This page is specific to

Microsoft Visual Studio 2008/.NET Framework 3.5

Other versions are also available for the following:

.NET Framework Class Library

SqlConnectionStringBuilder..::.UserInstance Property

Gets or sets a value that indicates whether to redirect the connection from the default SQL Server Express instance to a runtime-initiated instance running under the account of the caller.

Namespace: System.Data.SqlClient
Assembly: System.Data (in System.Data.dll)

Syntax

Visual Basic (Declaration)

Public Property UserInstance As Boolean

Visual Basic (Usage)

Dim instance As SqlConnectionStringBuilder
Dim value As Boolean

value = instance.UserInstance

instance.UserInstance = value

public bool UserInstance { get; set; }

Visual C++

public:
property bool UserInstance {
    bool get ();
    void set (bool value);
}

JScript

public function get UserInstance () : boolean
public function set UserInstance (value : boolean)

Property Value

Type: System..::.Boolean
The value of the UserInstance property, or False if none has been supplied.

Remarks

This property corresponds to the "User Instance" key within the connection string. If the value passed in is null when you try to set the property, the UserInstance property is reset. If the value has not been set and the developer tries to retrieve the property, the return value is False.

Note:
This feature is available only with the SQL Server 2005 Express Edition. For more information on user instances, see SQL Server Express User Instances (ADO.NET) and "User Instances for Non-Administrators" in SQL Server Books Online.

Platforms

Windows 7, Windows Vista, Windows XP SP2, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP Starter Edition, Windows Server 2008 R2, Windows Server 2008, Windows Server 2003, Windows Server 2000 SP4, Windows Millennium Edition, Windows 98

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

Version Information

.NET Framework

Supported in: 3.5, 3.0, 2.0

Reference

SqlConnectionStringBuilder Class

SqlConnectionStringBuilder Members

System.Data.SqlClient Namespace

Other Resources

Connection Strings (ADO.NET)