ServerConnection Constructor (SqlConnection)

Initializes a new instance of the ServerConnection class with the specified connection parameters.

Namespace:  Microsoft.SqlServer.Management.Common
Assembly:  Microsoft.SqlServer.ConnectionInfo (in Microsoft.SqlServer.ConnectionInfo.dll)

Syntax

'Declaration
Public Sub New ( _
    sqlConnection As SqlConnection _
)
'Usage
Dim sqlConnection As SqlConnection 

Dim instance As New ServerConnection(sqlConnection)

public ServerConnection(
    SqlConnection sqlConnection
)

public:
ServerConnection(
    SqlConnection^ sqlConnection
)

new : 
        sqlConnection:SqlConnection -> ServerConnection

public function ServerConnection(
    sqlConnection : SqlConnection
)

Parameters

• sqlConnection
  Type: System.Data.SqlClient.SqlConnection
  A SqlConnection system object that specifies connection parameters associated with the referenced connection.

Examples

C#

String connectionString = "Data Source=(local);Initial Catalog=AdventureWorks2012;Integrated Security=SSPI;";
SqlConnection sqlConnection = new SqlConnection(connectionString);
ServerConnection conn = new ServerConnection(sqlConnection);
Server srv = new Server(conn);
Console.WriteLine(srv.Information.Version);

PowerShell

$connectionString = "Data Source=(local);Initial Catalog=AdventureWorks2012;Integrated Security=SSPI;"
$sqlConnection = new-object System.Data.SqlClient.SqlConnection($connectionString)
$conn = new-object Microsoft.SqlServer.Management.Common.ServerConnection($sqlConnection)
#Connect to the local, default instance of SQL Server
$srv = new-object Microsoft.SqlServer.Management.Smo.Server($conn)
Write-Host $srv.Information.Version

See Also

Reference

ServerConnection Class

ServerConnection Overload

Microsoft.SqlServer.Management.Common Namespace

Other Resources

Connecting to an Instance of SQL Server