Click or drag to resize
DatabaseHelper Class
Provides database operations
Inheritance Hierarchy
SystemObject
  CMS.DataEngineDatabaseHelper

Namespace: CMS.DataEngine
Assembly: CMS.DataEngine (in CMS.DataEngine.dll) Version: 11.0.0
Syntax
C#
public static class DatabaseHelper

The DatabaseHelper type exposes the following members.

Fields
  NameDescription
Public fieldStatic memberDEFAULT_DB_COLLATION
Default database collation
Top
Properties
  NameDescription
Public propertyStatic memberDatabaseCollation
Database collation.
Public propertyStatic memberDatabaseVersion
Returns the version of the database that the application uses. Returns null if connection string is not initialized.
Public propertyStatic memberIsCorrectDatabaseVersion
Returns whether database version is correct and matches the application version.
Public propertyStatic memberIsDatabaseAvailable
Indicates whether connection string is set and objects exist in database.
Top
Methods
  NameDescription
Public methodStatic memberChangeDatabaseCollation
Change the collation of specified database.
Public methodStatic memberCheckDatabaseVersion
Checks the database version, returns true if the version is correct, reports error in case the version is wrong
Public methodStatic memberCheckDBPermission
Checks if SQL account is granted with specific permission.
Public methodStatic memberDatabaseExists
Checks if the specified database exists, returns true if database exists.
Public methodStatic memberGetDatabaseCollation
Returns database collation.
Public methodStatic memberGetDatabaseName
Returns the database name.
Public methodStatic memberIsSupportedDatabaseCollation
Checks if the specified collation is supported.
Top
See Also