/// <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); }