Class ExtDatasourceTableInfo
Table 'ext_datasource': This table contains external datasources, used for databaseintegration of customers and companies.
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 startsDeclaration
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 LinuxDeclaration
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 farDeclaration
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 farDeclaration
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 updateDeclaration
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 simultaniouslyDeclaration
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().