SqlConnection.ChangeDatabase Method
.NET Framework 4.5
Changes the current database for an open SqlConnection.
Namespace: System.Data.SqlClient
Assembly: System.Data (in System.Data.dll)
Parameters
- database
- Type: System.String
The name of the database to use instead of the current database.
Implements
IDbConnection.ChangeDatabase(String)| Exception | Condition |
|---|---|
| ArgumentException | The database name is not valid. |
| InvalidOperationException | The connection is not open. |
| SqlException | Cannot change the database. |
The following example creates a SqlConnection and displays some of its read-only properties.
private static void ChangeSqlDatabase(string connectionString) { // Assumes connectionString represents a valid connection string // to the AdventureWorks sample database. using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); Console.WriteLine("ServerVersion: {0}", connection.ServerVersion); Console.WriteLine("Database: {0}", connection.Database); connection.ChangeDatabase("Northwind"); Console.WriteLine("Database: {0}", connection.Database); } }
Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.