Class Helpers
- Namespace
- Dynamicweb.Data
- Assembly
- Dynamicweb.Core.dll
Provides database utility methods including collation name resolution, transaction scope management, and database compatibility checks.
public class Helpers
- Inheritance
-
Helpers
- Inherited Members
Fields
RequiredDatabaseCompatibilityLevel
Required database compatibility level for running Dynamicweb CMS
public static readonly int RequiredDatabaseCompatibilityLevel
Field Value
Methods
CreateTransactionScope()
Creates a TransactionScope with the isolation level set to ReadCommitted and 10 minute timeout
public static TransactionScope CreateTransactionScope()
Returns
- TransactionScope
An TransactionScope instance.
CreateTransactionScope(TimeSpan)
Creates a TransactionScope with the isolation level set to ReadCommitted
public static TransactionScope CreateTransactionScope(TimeSpan timeout)
Parameters
timeoutTimeSpanThe transaction timeout.
Returns
- TransactionScope
An TransactionScope instance.
GetDatabaseCompatibilityLevel()
Gets the compatibility level of the current database
public static int GetDatabaseCompatibilityLevel()
Returns
- int
The Compatibility Level value
GetDatabaseCompatibilityLevel(IDbConnection)
Gets the compatibility level of the current database
public static int GetDatabaseCompatibilityLevel(IDbConnection connection)
Parameters
connectionIDbConnection
Returns
- int
The Compatibility Level value
GetNameOfSqlCollation(CultureInfo)
Gets the name of the SQL collation for a given CultureInfo.
public static string GetNameOfSqlCollation(CultureInfo culture)
Parameters
cultureCultureInfoThe culture.
Returns
- string
System.String.