This topic has not yet been rated - Rate this topic

ConnectionSettings.DatabaseName Property

SQL Server 2012

Gets or sets the database required by the connection.

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

Syntax

C++

JScript

public string DatabaseName { get; set; }

Property Value

Type: System.String
A String value that specifies the name of the database specified by the connection.

Examples

VBNET

'Connect to the local, default instance of SQL Server.
Dim srv1 As Server
srv1 = New Server()
'Modify the default database and the timeout period for the connection.
srv1.ConnectionContext.DatabaseName = "AdventureWorks2012"
srv1.ConnectionContext.ConnectTimeout = 30
'Make a second connection using a copy of the ConnectionContext property and verify settings.
Dim srv2 As Server
srv2 = New Server(srv1.ConnectionContext.Copy)
Console.WriteLine(srv2.ConnectionContext.ConnectTimeout.ToString)

Reference

ConnectionSettings Class

Microsoft.SqlServer.Management.Common Namespace

Other Resources

Calling Methods

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD