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: 9.0.0
Syntax
C#
public static class DatabaseHelper

The DatabaseHelper type exposes the following members.

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 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 memberChangeDatabaseCollation(String, String)
Change the collation of specified database.
Public methodStatic memberChangeDatabaseCollation(String, String, String)
Change the collation of specified database.
Public methodStatic memberCheckDatabaseCollation
Checks if the specified database has correct collation.
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.
Top
See Also