SqlConnection.WorkstationId Property

Reference

Definition

Namespace:: System.Data.SqlClient

Assembly:: System.Data.SqlClient.dll

Assembly:: System.Data.dll

Package:: System.Data.SqlClient v4.9.0

Source:: System.Data.SqlClient.notsupported.cs

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 a string that identifies the database client.

public:
 property System::String ^ WorkstationId { System::String ^ get(); };

public string WorkstationId { get; }

[System.Data.DataSysDescription("SqlConnection_WorkstationId")]
public string WorkstationId { get; }

member this.WorkstationId : string

[<System.Data.DataSysDescription("SqlConnection_WorkstationId")>]
member this.WorkstationId : string

Public ReadOnly Property WorkstationId As String

Property Value

String

A string that identifies the database client. If not specified, the name of the client computer. If neither is specified, the value is an empty string.

Attributes: DataSysDescriptionAttribute

Examples

The following example creates a SqlConnection and displays the WorkstationId property.

private static void OpenSqlConnection(string connectionString)
{
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();
        Console.WriteLine("ServerVersion: {0}", connection.ServerVersion);
        Console.WriteLine("WorkstationId: {0}", connection.WorkstationId);
    }
}

Private Sub OpenSqlConnection(ByVal connectionString As String)
    Using connection As New SqlConnection(connectionString)
        connection.Open()
        Console.WriteLine("ServerVersion: {0}", connection.ServerVersion)
        Console.WriteLine("WorkstationId: {0}", connection.WorkstationId)
    End Using
End Sub

Remarks

The string typically contains the network name of the client. The WorkstationId property corresponds to the Workstation ID connection string property.

Applies to

Produkt	Versioner
.NET	Core 1.0, Core 1.1, 6 (package-provided), 7 (package-provided), 8 (package-provided), 9 (package-provided), 10 (package-provided)
.NET Framework	1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1
.NET Standard	2.0 (package-provided)

Dela via