Class ExtDatasourceTableInfo

Table 'ext_datasource': This table contains external datasources, used for databaseintegration of customers and companies.

Inheritance
object
TableInfo
ExtDatasourceTableInfo
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("ext_datasource")]
public class ExtDatasourceTableInfo : TableInfo, ICloneable
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

Fields

DictionaryTableName

Conceptual name of table ExtDatasource in the database dictionary: ext_datasource

Declaration
public const string DictionaryTableName = "ext_datasource"
Field Value
Type Description
string
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

Properties

DatabaseType

Field 'database_type' in table 'ext_datasource': Dictionary type Int, .NET type: int

The database type (DbType).
Declaration
public Int32FieldInfo DatabaseType { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

Datatype

Field 'datatype' in table 'ext_datasource': Dictionary type String[33], .NET type: string

An enum indicating the type/protocol for this datasource.
Declaration
public StringFieldInfo Datatype { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

Dbname

Field 'dbname' in table 'ext_datasource': Dictionary type String[33], .NET type: string

The name used for accessing the datasource.
Declaration
public StringFieldInfo Dbname { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration
public override SoTable Definition { get; }
Property Value
Type Description
SoTable
Overrides
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

DictionaryTableNumber

Table number for table ExtDatasource in the database dictionary; potentially changes between databases, but always the same over the lifetime of any single database

Declaration
public int DictionaryTableNumber { get; }
Property Value
Type Description
int
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

ExtDatasourceId

Field 'id' in table 'ext_datasource': Dictionary type PK, .NET type: int

The primary key (auto-incremented)
Declaration
public Int32FieldInfo ExtDatasourceId { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

Flags

Field 'flags' in table 'ext_datasource': Dictionary type Int, .NET type: int

Bitmask of flags.
Declaration
public Int32FieldInfo Flags { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

Hostname

Field 'hostname' in table 'ext_datasource': Dictionary type String[256], .NET type: string

The hostname for accessing the datasource.
Declaration
public StringFieldInfo Hostname { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

LastAccess

Field 'last_access' in table 'ext_datasource': Dictionary type DateTime, .NET type: DateTime

The last time this datasource was accessed.
Declaration
public DateTimeFieldInfo LastAccess { get; }
Property Value
Type Description
DateTimeFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

LastUpdate

Field 'last_update' in table 'ext_datasource': Dictionary type DateTime, .NET type: DateTime

When did the last update occur?.
Declaration
public DateTimeFieldInfo LastUpdate { get; }
Property Value
Type Description
DateTimeFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

LeftOuterJoin_ExtTable_ExtDatasource

Generated left outer join from the primary key ExtDatasourceId on this table, to ExtTable.ExtDatasource.

Declaration
public TargetedLeftOuterJoin<ExtTableTableInfo> LeftOuterJoin_ExtTable_ExtDatasource { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ExtTableTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

Name

Field 'name' in table 'ext_datasource': Dictionary type String[65], .NET type: string

An alias for this datasource.
Declaration
public StringFieldInfo Name { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

NextUpdate

Field 'next_update' in table 'ext_datasource': Dictionary type DateTime, .NET type: DateTime

Next time the update process starts
Declaration
public DateTimeFieldInfo NextUpdate { get; }
Property Value
Type Description
DateTimeFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

Password

Field 'password' in table 'ext_datasource': Dictionary type String[65], .NET type: string

The poassword used for authenticating against the datasource.
Declaration
public StringFieldInfo Password { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

Path

Field 'path' in table 'ext_datasource': Dictionary type String[256], .NET type: string

Path to the datasource.
Declaration
public StringFieldInfo Path { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

Port

Field 'port' in table 'ext_datasource': Dictionary type Int, .NET type: int

The port used for accessing the datasource.
Declaration
public Int32FieldInfo Port { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration
[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }
Property Value
Type Description
SoTable
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

SqlInit

Field 'sql_init' in table 'ext_datasource': Dictionary type Clob, .NET type: string

The SQL init used for configure the server before fetching external data.
Declaration
public StringFieldInfo SqlInit { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

UnixSocket

Field 'unix_socket' in table 'ext_datasource': Dictionary type String[256], .NET type: string

Unix socket used with Mysql connections on Linux
Declaration
public StringFieldInfo UnixSocket { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

UpdateCompanyCount

Field 'update_company_count' in table 'ext_datasource': Dictionary type Int, .NET type: int

Number of companies updated so far
Declaration
public Int32FieldInfo UpdateCompanyCount { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

UpdateCompletionTime

Field 'update_completion_time' in table 'ext_datasource': Dictionary type Int, .NET type: int

The last update completion time in minutes.
Declaration
public Int32FieldInfo UpdateCompletionTime { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

UpdateCustomerCount

Field 'update_customer_count' in table 'ext_datasource': Dictionary type Int, .NET type: int

Number of customers updated so far
Declaration
public Int32FieldInfo UpdateCustomerCount { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

UpdateErrorMessage

Field 'update_error_message' in table 'ext_datasource': Dictionary type Clob, .NET type: string

The last error message from datasource update.
Declaration
public StringFieldInfo UpdateErrorMessage { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

UpdateInterval

Field 'update_interval' in table 'ext_datasource': Dictionary type Int, .NET type: int

Number of hours between each database update
Declaration
public Int32FieldInfo UpdateInterval { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

UpdateLock

Field 'update_lock' in table 'ext_datasource': Dictionary type DateTime, .NET type: DateTime

Lock to make sure not 2 updates are done simultaniously
Declaration
public DateTimeFieldInfo UpdateLock { get; }
Property Value
Type Description
DateTimeFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

Username

Field 'username' in table 'ext_datasource': Dictionary type String[65], .NET type: string

The username used for authenticating against the datasource.
Declaration
public StringFieldInfo Username { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetExtDatasourceInfo().

Implements

Extension Methods