Class ConfigFile.Data.Database

Utility class used to access the SuperOffice.Data.Database entry in the config-file.

Inheritance

System.Object

ConfigFile.Data.Database

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: SuperOffice.Configuration

Assembly: SoCore.dll

Syntax

public static class Database

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
System.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
System.Int32

ConnectionString

The connection string formatted as a "template".

Declaration

public static string ConnectionString { get; set; }

Property Value

Type	Description
System.String

DatabaseMajor

Major name of database provider

Declaration

public static string DatabaseMajor { get; set; }

Property Value

Type	Description
System.String

DatabaseMinor

Version number of Database

Declaration

public static string DatabaseMinor { get; set; }

Property Value

Type	Description
System.String

DatabaseName

Name of the database. Also used for distinct service name.

Declaration

public static string DatabaseName { get; set; }

Property Value

Type	Description
System.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
System.String

DynamicLoadedDataBaseDriver

Returns the name of the ADO.NET driver to load.

Declaration

public static string DynamicLoadedDataBaseDriver { get; set; }

Property Value

Type	Description
System.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
System.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
System.String

TablePrefix

The prefix of the SuperOffice CRM tables in the database.

Declaration

public static string TablePrefix { get; set; }

Property Value

Type	Description
System.String