Class ExtTableRecordData

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

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

Please use this class instead of a full ExtTableRow 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 ExtTableTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Constructors

ExtTableRecordData()

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

Declaration
public ExtTableRecordData()
Remarks

Please use this class instead of a full ExtTableRow 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 ExtTableTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Fields

ChildTable

The reference to the child table.

Declaration
public int ChildTable
Field Value
Type Description
Int32
Remarks

Please use this class instead of a full ExtTableRow 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 ExtTableTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ExtDatasource

The reference to the associated datasource.

Declaration
public int ExtDatasource
Field Value
Type Description
Int32
Remarks

Please use this class instead of a full ExtTableRow 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 ExtTableTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ExtTableId

The primary key (auto-incremented)

Declaration
public int ExtTableId
Field Value
Type Description
Int32
Remarks

Please use this class instead of a full ExtTableRow 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 ExtTableTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

LdapSearchBase2

LDAP search base, multiple search bases are seperated by new line

Declaration
public string LdapSearchBase2
Field Value
Type Description
String
Remarks

Please use this class instead of a full ExtTableRow 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 ExtTableTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

LdapSearchFilter

LDAP search query

Declaration
public string LdapSearchFilter
Field Value
Type Description
String
Remarks

Please use this class instead of a full ExtTableRow 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 ExtTableTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

LdapSearchResult

Select which data to return from LDAP

Declaration
public string LdapSearchResult
Field Value
Type Description
String
Remarks

Please use this class instead of a full ExtTableRow 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 ExtTableTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Name

The name for this field

Declaration
public string Name
Field Value
Type Description
String
Remarks

Please use this class instead of a full ExtTableRow 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 ExtTableTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

ParentTable

The reference to the parent table.

Declaration
public int ParentTable
Field Value
Type Description
Int32
Remarks

Please use this class instead of a full ExtTableRow 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 ExtTableTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

PrimaryKey

The name of the primary key. TODO: depreciated?

Declaration
public string PrimaryKey
Field Value
Type Description
String
Remarks

Please use this class instead of a full ExtTableRow 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 ExtTableTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Priority

TODO: depreciated?

Declaration
public int Priority
Field Value
Type Description
Int32
Remarks

Please use this class instead of a full ExtTableRow 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 ExtTableTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SqlLimit

Used for LIMIT optimiziation of the search query

Declaration
public int SqlLimit
Field Value
Type Description
Int32
Remarks

Please use this class instead of a full ExtTableRow 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 ExtTableTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SqlQuery

The SQL query used for fetching the external data.

Declaration
public string SqlQuery
Field Value
Type Description
String
Remarks

Please use this class instead of a full ExtTableRow 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 ExtTableTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

SqlQuery2

The SQL query used for fetching the external data. Part 2

Declaration
public string SqlQuery2
Field Value
Type Description
String
Remarks

Please use this class instead of a full ExtTableRow 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 ExtTableTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.

Target

Enum indicating the target table (customer or cust_company).

Declaration
public int Target
Field Value
Type Description
Int32
Remarks

Please use this class instead of a full ExtTableRow 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 ExtTableTableInfo 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)