Class ExtDatasourceRecordData

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the ext_datasource table.

Inheritance
Object
ExtDatasourceRecordData
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public class ExtDatasourceRecordData : Object
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Constructors

ExtDatasourceRecordData()

POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the ext_datasource table.

Declaration
public ExtDatasourceRecordData()
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Fields

DatabaseType

The database type (DbType).

Declaration
public int DatabaseType
Field Value
Type Description
Int32
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Datatype

An enum indicating the type/protocol for this datasource.

Declaration
public string Datatype
Field Value
Type Description
String
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Dbname

The name used for accessing the datasource.

Declaration
public string Dbname
Field Value
Type Description
String
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ExtDatasourceId

The primary key (auto-incremented)

Declaration
public int ExtDatasourceId
Field Value
Type Description
Int32
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Flags

Bitmask of flags.

Declaration
public int Flags
Field Value
Type Description
Int32
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Hostname

The hostname for accessing the datasource.

Declaration
public string Hostname
Field Value
Type Description
String
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

LastAccess

The last time this datasource was accessed.

Declaration
public DateTime LastAccess
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

LastUpdate

When did the last update occur?.

Declaration
public DateTime LastUpdate
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Name

An alias for this datasource.

Declaration
public string Name
Field Value
Type Description
String
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

NextUpdate

Next time the update process starts

Declaration
public DateTime NextUpdate
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Password

The poassword used for authenticating against the datasource.

Declaration
public string Password
Field Value
Type Description
String
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Path

Path to the datasource.

Declaration
public string Path
Field Value
Type Description
String
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Port

The port used for accessing the datasource.

Declaration
public int Port
Field Value
Type Description
Int32
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SqlInit

The SQL init used for configure the server before fetching external data.

Declaration
public string SqlInit
Field Value
Type Description
String
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UnixSocket

Unix socket used with Mysql connections on Linux

Declaration
public string UnixSocket
Field Value
Type Description
String
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UpdateCompanyCount

Number of companies updated so far

Declaration
public int UpdateCompanyCount
Field Value
Type Description
Int32
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UpdateCompletionTime

The last update completion time in minutes.

Declaration
public int UpdateCompletionTime
Field Value
Type Description
Int32
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UpdateCustomerCount

Number of customers updated so far

Declaration
public int UpdateCustomerCount
Field Value
Type Description
Int32
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UpdateErrorMessage

The last error message from datasource update.

Declaration
public string UpdateErrorMessage
Field Value
Type Description
String
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UpdateInterval

Number of hours between each database update

Declaration
public int UpdateInterval
Field Value
Type Description
Int32
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

UpdateLock

Lock to make sure not 2 updates are done simultaniously

Declaration
public DateTime UpdateLock
Field Value
Type Description
DateTime
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Username

The username used for authenticating against the datasource.

Declaration
public string Username
Field Value
Type Description
String
Remarks

Please use this class instead of a full ExtDatasourceRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding ExtDatasourceTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Extension Methods

EnumUtil.MapEnums<From, To>(From)