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=AdventureWorks2008R2;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=AdventureWorks2008R2;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