本文整理汇总了C#中IDbConnection.ChangeDatabase方法的典型用法代码示例。如果您正苦于以下问题：C# IDbConnection.ChangeDatabase方法的具体用法？C# IDbConnection.ChangeDatabase怎么用？C# IDbConnection.ChangeDatabase使用的例子？那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IDbConnection的用法示例。
在下文中一共展示了IDbConnection.ChangeDatabase方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetDatabaseNames
/// <summary>
/// Returns a list of database names.
/// </summary>
/// <param name="connection">A database connection to a server containing geodatabases.</param>
/// <returns></returns>
public static List<string> GetDatabaseNames(IDbConnection connection)
{
if (connection == null)
{
throw new ArgumentNullException("connection");
}
// Store the initial connection state. If the connection is already open we will leave it open instead of closing it.
var initConnectionState = connection.State;
// Store the initial database in case we need to change it.
string originalDatabase = connection.Database;
List<string> output = null;
try
{
// Open the connection if it is not already open.
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
// We need to use the "master" database.
if (string.Compare(connection.Database, "master", true) != 0)
{
Trace.WriteLine(string.Format("Changing database from {0} to master...", connection.Database));
connection.ChangeDatabase("master");
}
// Create the command to select the list of databases.
var cmd = connection.CreateCommand();
cmd.CommandText = Resources.ListDatabases;
// Initialize the list of database names.
output = new List<string>();
// Execute the command and store the database names that are returned.
using (var reader = cmd.ExecuteReader(CommandBehavior.Default))
{
while (reader.Read())
{
string s = reader.GetString(0);
output.Add(s);
}
}
}
finally
{
// Close the connection ONLY if it was not already opened when we started.
if (connection != null && initConnectionState != ConnectionState.Open)
{
connection.Close();
}
}
return output;
}示例2: SetUpConnection
protected virtual void SetUpConnection(IDbConnection cnx)
{
if (shouldOpen && cnx.State != ConnectionState.Open)
cnx.Open();
if (databaseName != null)
cnx.ChangeDatabase(databaseName);
}