/// <summary>
/// Checks if the database exists.
/// </summary>
/// <param name="name">The database name.</param>
/// <param name="userName">The user name to connect to database.</param>
/// <param name="password">The password of the user.</param>
/// <param name="databaseServerId">The identifier of the the SQL-server where database is placed.</param>
/// <param name="errorMessage">The error message if an error occured.</param>
/// <returns>true, if the database exists; otherwise, false.</returns>
internal static bool DatabaseExists(string name, string userName, string password, Guid databaseServerId, out string errorMessage)
{
bool success = false;
errorMessage = string.Empty;
MasterDataSet.DatabaseServerRow row = DatabaseServerProvider.GetDatabaseServerRow(databaseServerId);
if (row != null)
{
string connectionString = CreateConnectionString(name, userName, password, row.Name, row.InstanceName, row.Port);
SqlConnection connection = null;
try
{
connection = new SqlConnection(connectionString);
connection.Open();
success = true;
}
catch (SqlException ex)
{
errorMessage = ex.Message;
}
finally
{
if (connection != null)
{
connection.Dispose();
}
}
}
return(success);
}
/// <summary>
/// Marks as deleted the specified SQL-server.
/// </summary>
/// <param name="databaseServerId">Specifies the SQL-server's identifier.</param>
public static void DeleteDatabaseServer(Guid databaseServerId)
{
MasterDataSet.DatabaseServerRow row = GetDatabaseServerRow(databaseServerId);
if (row == null)
{
return;
}
row.Deleted = true;
using (DatabaseServerTableAdapter adapter = new DatabaseServerTableAdapter())
{
adapter.Update(row);
}
}
/// <summary>
/// Returns the SQL-server full name, where the specified database is placed.
/// </summary>
/// <param name="databaseId">Specifies the database identifier.</param>
/// <returns>The System.String that represents the SQL-server full name, where the specified database is placed.</returns>
internal static string GetDatabaseServerFullNameByDatabaseId(Guid databaseId)
{
MasterDataSet.DatabaseServerRow row = GetDatabaseServerRowByDatabaseId(databaseId);
return((row == null) ? string.Empty : row.FullName);
}
