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
Fields
DictionaryTableName
Conceptual name of table ExtDatasource in the database dictionary: ext_datasource
Declaration
public const string DictionaryTableName = "ext_datasource"
Field Value
Type | Description |
---|---|
System.String |
Properties
DatabaseType
Field 'database_type' in table 'ext_datasource': Dictionary type Int, .NET type: System.Int32
The database type (DbType).
Declaration
public Int32FieldInfo DatabaseType { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Datatype
Field 'datatype' in table 'ext_datasource': Dictionary type String[33], .NET type: System.String
An enum indicating the type/protocol for this datasource.
Declaration
public StringFieldInfo Datatype { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Dbname
Field 'dbname' in table 'ext_datasource': Dictionary type String[33], .NET type: System.String
The name used for accessing the datasource.
Declaration
public StringFieldInfo Dbname { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Definition
Definition of the table as described in the deployed runtime dictionary
Declaration
public override SoTable Definition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Overrides
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 |
---|---|
System.Int32 |
ExtDatasourceId
Field 'id' in table 'ext_datasource': Dictionary type PK, .NET type: System.Int32
The primary key (auto-incremented)
Declaration
public Int32FieldInfo ExtDatasourceId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Flags
Field 'flags' in table 'ext_datasource': Dictionary type Int, .NET type: System.Int32
Bitmask of flags.
Declaration
public Int32FieldInfo Flags { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Hostname
Field 'hostname' in table 'ext_datasource': Dictionary type String[256], .NET type: System.String
The hostname for accessing the datasource.
Declaration
public StringFieldInfo Hostname { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
LastAccess
Field 'last_access' in table 'ext_datasource': Dictionary type DateTime, .NET type: System.DateTime
The last time this datasource was accessed.
Declaration
public DateTimeFieldInfo LastAccess { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
LastUpdate
Field 'last_update' in table 'ext_datasource': Dictionary type DateTime, .NET type: System.DateTime
When did the last update occur?.
Declaration
public DateTimeFieldInfo LastUpdate { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
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> |
Name
Field 'name' in table 'ext_datasource': Dictionary type String[65], .NET type: System.String
An alias for this datasource.
Declaration
public StringFieldInfo Name { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
NextUpdate
Field 'next_update' in table 'ext_datasource': Dictionary type DateTime, .NET type: System.DateTime
Next time the update process starts
Declaration
public DateTimeFieldInfo NextUpdate { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Password
Field 'password' in table 'ext_datasource': Dictionary type String[65], .NET type: System.String
The poassword used for authenticating against the datasource.
Declaration
public StringFieldInfo Password { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Path
Field 'path' in table 'ext_datasource': Dictionary type String[256], .NET type: System.String
Path to the datasource.
Declaration
public StringFieldInfo Path { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Port
Field 'port' in table 'ext_datasource': Dictionary type Int, .NET type: System.Int32
The port used for accessing the datasource.
Declaration
public Int32FieldInfo Port { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 |
SqlInit
Field 'sql_init' in table 'ext_datasource': Dictionary type Clob, .NET type: System.String
The SQL init used for configure the server before fetching external data.
Declaration
public StringFieldInfo SqlInit { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
UnixSocket
Field 'unix_socket' in table 'ext_datasource': Dictionary type String[256], .NET type: System.String
Unix socket used with Mysql connections on Linux
Declaration
public StringFieldInfo UnixSocket { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
UpdateCompanyCount
Field 'update_company_count' in table 'ext_datasource': Dictionary type Int, .NET type: System.Int32
Number of companies updated so far
Declaration
public Int32FieldInfo UpdateCompanyCount { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
UpdateCompletionTime
Field 'update_completion_time' in table 'ext_datasource': Dictionary type Int, .NET type: System.Int32
The last update completion time in minutes.
Declaration
public Int32FieldInfo UpdateCompletionTime { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
UpdateCustomerCount
Field 'update_customer_count' in table 'ext_datasource': Dictionary type Int, .NET type: System.Int32
Number of customers updated so far
Declaration
public Int32FieldInfo UpdateCustomerCount { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
UpdateErrorMessage
Field 'update_error_message' in table 'ext_datasource': Dictionary type Clob, .NET type: System.String
The last error message from datasource update.
Declaration
public StringFieldInfo UpdateErrorMessage { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
UpdateInterval
Field 'update_interval' in table 'ext_datasource': Dictionary type Int, .NET type: System.Int32
Number of hours between each database update
Declaration
public Int32FieldInfo UpdateInterval { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
UpdateLock
Field 'update_lock' in table 'ext_datasource': Dictionary type DateTime, .NET type: System.DateTime
Lock to make sure not 2 updates are done simultaniously
Declaration
public DateTimeFieldInfo UpdateLock { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Username
Field 'username' in table 'ext_datasource': Dictionary type String[65], .NET type: System.String
The username used for authenticating against the datasource.
Declaration
public StringFieldInfo Username { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |