Class ConfigFile.Data.Database
Utility class used to access the SuperOffice.Data.Database entry in the config-file.
Namespace: SuperOffice.Configuration
Assembly: SoCore.dll
Syntax
public static class Database : Object
Properties
CacheCheckInterval
Number of seconds to check if cache are outdated and refersh. 0 will disable the timer.
Declaration
public static int CacheCheckInterval { get; set; }
Property Value
Type | Description |
---|---|
Int32 |
CommandTimeout
Timeout in seconds for the command to wait for a response from the database.
Declaration
public static int CommandTimeout { get; set; }
Property Value
Type | Description |
---|---|
Int32 |
ConnectionString
The connection string formatted as a "template".
Declaration
public static string ConnectionString { get; set; }
Property Value
Type | Description |
---|---|
String |
DatabaseMajor
Major name of database provider
Declaration
public static string DatabaseMajor { get; set; }
Property Value
Type | Description |
---|---|
String |
DatabaseMinor
Version number of Database
Declaration
public static string DatabaseMinor { get; set; }
Property Value
Type | Description |
---|---|
String |
DatabaseName
Name of the database. Also used for distinct service name.
Declaration
public static string DatabaseName { get; set; }
Property Value
Type | Description |
---|---|
String |
DefaultReadUncommitted
Should SELECTs by default run in "ReadUncommitted" isolation level, lessening locking contention (especially on SQL Server)? Default setting is TRUE.
Declaration
public static bool DefaultReadUncommitted { get; set; }
Property Value
Type | Description |
---|---|
Boolean |
DisableSqlTrackingComments
If true, then comments that usually precede generated SQL to identify the operation and user will not be generated at all; may help performance on Oracle which thinks it has to reparse everything if a comment changes
Declaration
public static bool DisableSqlTrackingComments { get; set; }
Property Value
Type | Description |
---|---|
Boolean |
DisableUserInSqlTrackingComments
If true, then comments that usually precede generated SQL to identify the operation will not contain associate information; may help performance on Oracle which thinks it has to reparse everything if a comment changes
Declaration
public static bool DisableUserInSqlTrackingComments { get; set; }
Property Value
Type | Description |
---|---|
Boolean |
DynamicLoadedConnectionType
Returns the type of connection to open.
Declaration
public static string DynamicLoadedConnectionType { get; set; }
Property Value
Type | Description |
---|---|
String |
DynamicLoadedDataBaseDriver
Returns the name of the ADO.NET driver to load.
Declaration
public static string DynamicLoadedDataBaseDriver { get; set; }
Property Value
Type | Description |
---|---|
String |
ForceCacheRefreshInterval
Number of seconds before caches are force refreshed. 0 will disable the timer.
Declaration
public static int ForceCacheRefreshInterval { get; set; }
Property Value
Type | Description |
---|---|
Int32 |
ImpersonateDatabaseUser
Should the DbUser be logged in with windows and impersonated when connecting to the database in order to support database integrated authentication.
Declaration
public static bool ImpersonateDatabaseUser { get; set; }
Property Value
Type | Description |
---|---|
Boolean |
Server
The server where the database is located
Declaration
public static string Server { get; set; }
Property Value
Type | Description |
---|---|
String |
TablePrefix
The prefix of the SuperOffice CRM tables in the database.
Declaration
public static string TablePrefix { get; set; }
Property Value
Type | Description |
---|---|
String |