DatabaseHelper Class

Provides database operations

Inheritance Hierarchy

System.Object
  CMS.DataEngine.DatabaseHelper

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 8.2.23

Syntax

public static class DatabaseHelper

The DatabaseHelper type exposes the following members.

Methods

	Name	Description
Public method Static member	DatabaseExists	Checks if the specified database exists, returns true if database exists.
Public method Static member	GetDatabaseCollation	Returns database collation.
Public method Static member	GetDatabaseName	Returns the database name.
Public method Static member	ChangeDatabaseCollation(String, String)	Change the collation of specified database.
Public method Static member	ChangeDatabaseCollation(String, String, String)	Change the collation of specified database.
Public method Static member	CheckDatabaseCollation	Checks if the specified database has correct collation.
Public method Static member	CheckDatabaseVersion	Checks the database version, returns true if the version is correct, reports error in case the version is wrong
Public method Static member	CheckDBPermission	Checks if SQL account is granted with specific permission.

Properties

	Name	Description
Public property Static member	DatabaseCollation	Database collation.
Public property Static member	DatabaseVersion	Returns the version of the database that the application uses. Returns null if connection string is not initialized.
Public property Static member	IsCorrectDatabaseVersion	Returns whether database version is correct and matches the application version.
Public property Static member	IsDatabaseAvailable	Indicates whether connection string is set and objects exist in database.