Class ContactTableInfo

Table 'contact': Companies and Organizations. This table features a special record containing information about the contact that owns the database.

Inheritance

Object

TableInfo

ContactTableInfo

Implements

ICloneable

Inherited Members

TableInfo.ToString()

TableInfo.RegisterFields(FieldInfo[])

TableInfo.FieldInfoFromSoField(SoField)

TableInfo.Clone()

TableInfo.IsSameTable(TableInfo)

TableInfo.FindField(String)

TableInfo.ProtAll

TableInfo.HashCheckFields

TableInfo.TableName

TableInfo.DbName

TableInfo.IsDictionaryTable

TableInfo.All

TableInfo.Item[String]

TableInfo.PrimaryKeyField

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

[DatabaseTable("contact")]
public class ContactTableInfo : 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 Contact in the database dictionary: contact

Declaration

public const string DictionaryTableName = "contact"

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 .

Properties

ActiveErpLinks

Field 'activeErpLinks' in table 'contact': Dictionary type Int, .NET type: Int32

The number of Erp Sync connections this record is synced with; count of the ErpExternalKey+ErpInternalKey relations

Declaration

public Int32FieldInfo ActiveErpLinks { 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 .

ActiveInterests

Field 'activeInterests' in table 'contact': Dictionary type UShort, .NET type: Int16

Number of records in cintr table; select count(*) from cintr ci where ci.contact_id = this.contact_id == activeInterests is always true

Declaration

public UInt16FieldInfo ActiveInterests { get; }

Property Value

Type	Description
UInt16FieldInfo

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 .

AssociateId

Field 'associate_id' in table 'contact': Dictionary type FK, target: Associate, .NET type: Int32

Our contact

Declaration

public Int32FieldInfo AssociateId { 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 .

AssociateId_InnerJoin_Associate

Generated join from the foreign key AssociateId in this table, to its target table AssociateTableInfo.

Declaration

public TargetedInnerJoin<AssociateTableInfo> AssociateId_InnerJoin_Associate { get; }

Property Value

Type	Description
TargetedInnerJoin<AssociateTableInfo>

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 .

BusinessIdx

Field 'business_idx' in table 'contact': Dictionary type FK, target: Business, .NET type: Int32

Link to Business

Declaration

public Int32FieldInfo BusinessIdx { 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 .

BusinessIdx_InnerJoin_Business

Generated join from the foreign key BusinessIdx in this table, to its target table BusinessTableInfo.

Declaration

public TargetedInnerJoin<BusinessTableInfo> BusinessIdx_InnerJoin_Business { get; }

Property Value

Type	Description
TargetedInnerJoin<BusinessTableInfo>

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 .

CategoryIdx

Field 'category_idx' in table 'contact': Dictionary type FK, target: Category, .NET type: Int32

Link to Category

Declaration

public Int32FieldInfo CategoryIdx { 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 .

CategoryIdx_InnerJoin_Category

Generated join from the foreign key CategoryIdx in this table, to its target table CategoryTableInfo.

Declaration

public TargetedInnerJoin<CategoryTableInfo> CategoryIdx_InnerJoin_Category { get; }

Property Value

Type	Description
TargetedInnerJoin<CategoryTableInfo>

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 .

ContactId

Field 'contact_id' in table 'contact': Dictionary type PK, .NET type: Int32

Primary key

Declaration

public Int32FieldInfo ContactId { 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 .

CountryId

Field 'country_id' in table 'contact': Dictionary type FK, target: Country, .NET type: Int32

Country

Declaration

public Int32FieldInfo CountryId { 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 .

CountryId_InnerJoin_Country

Generated join from the foreign key CountryId in this table, to its target table CountryTableInfo.

Declaration

public TargetedInnerJoin<CountryTableInfo> CountryId_InnerJoin_Country { get; }

Property Value

Type	Description
TargetedInnerJoin<CountryTableInfo>

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 .

DbiAgentId

Field 'dbi_agent_id' in table 'contact': Dictionary type FK, target: DbiAgent, .NET type: Int32

Integration agent (eJournal)

Declaration

public Int32FieldInfo DbiAgentId { 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 .

DbiAgentId_InnerJoin_DbiAgent

Generated join from the foreign key DbiAgentId in this table, to its target table DbiAgentTableInfo.

Declaration

public TargetedInnerJoin<DbiAgentTableInfo> DbiAgentId_InnerJoin_DbiAgent { get; }

Property Value

Type	Description
TargetedInnerJoin<DbiAgentTableInfo>

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 .

DbiKey

Field 'dbi_key' in table 'contact': Dictionary type String[256], .NET type: String

The primary key for the integrated entry in the external datasource.

Declaration

public StringFieldInfo DbiKey { 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 .

DbiLastModified

Field 'dbi_last_modified' in table 'contact': Dictionary type DateTime, .NET type: DateTime

When the entry was last modified.

Declaration

public DateTimeFieldInfo DbiLastModified { 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 .

DbiLastSyncronized

Field 'dbi_last_syncronized' in table 'contact': Dictionary type DateTime, .NET type: DateTime

Last external syncronization.

Declaration

public DateTimeFieldInfo DbiLastSyncronized { 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 .

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration

public override SoTable Definition { get; }

Property Value

Type	Description
SoTable

Overrides

TableInfo.Definition

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 .

Deleted

Field 'deleted' in table 'contact': Dictionary type UShort, .NET type: Int16

If nonzero, then this contact is 'deleted' and should generally not be shown

Declaration

public UInt16FieldInfo Deleted { get; }

Property Value

Type	Description
UInt16FieldInfo

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 .

DeletedDate

Field 'DeletedDate' in table 'contact': Dictionary type UtcDateTime, .NET type: DateTime

Datetime (utc) when this record was soft-deleted; if this value is set then the record should not be shown

Declaration

public DateTimeFieldInfo DeletedDate { 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 .

Department

Field 'department' in table 'contact': Dictionary type String[220], .NET type: String

Department

Declaration

public StringFieldInfo Department { 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 .

DictionaryTableNumber

Table number for table Contact 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
Int32

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 .

GroupId

Field 'group_id' in table 'contact': Dictionary type FK, target: UserGroup, .NET type: Int32

Group id of original owning associate, semantics like appnt.grp_id

Declaration

public Int32FieldInfo GroupId { 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 .

GroupId_InnerJoin_UserGroup

Generated join from the foreign key GroupId in this table, to its target table UserGroupTableInfo.

Declaration

public TargetedInnerJoin<UserGroupTableInfo> GroupId_InnerJoin_UserGroup { get; }

Property Value

Type	Description
TargetedInnerJoin<UserGroupTableInfo>

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 .

Kananame

Field 'kananame' in table 'contact': Dictionary type String[220], .NET type: String

Contact kana name, used in Japanese versions only

Declaration

public StringFieldInfo Kananame { 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 .

LeftOuterJoin_Appointment_ContactId

Generated left outer join from the primary key ContactId on this table, to Appointment.ContactId.

Declaration

public TargetedLeftOuterJoin<AppointmentTableInfo> LeftOuterJoin_Appointment_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<AppointmentTableInfo>

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 .

LeftOuterJoin_ChatSession_ContactId

Generated left outer join from the primary key ContactId on this table, to ChatSession.ContactId.

Declaration

public TargetedLeftOuterJoin<ChatSessionTableInfo> LeftOuterJoin_ChatSession_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<ChatSessionTableInfo>

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 .

LeftOuterJoin_CompanyDomain_CompanyId

Generated left outer join from the primary key ContactId on this table, to CompanyDomain.CompanyId.

Declaration

public TargetedLeftOuterJoin<CompanyDomainTableInfo> LeftOuterJoin_CompanyDomain_CompanyId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<CompanyDomainTableInfo>

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 .

LeftOuterJoin_ContactInterest_ContactId

Generated left outer join from the primary key ContactId on this table, to ContactInterest.ContactId.

Declaration

public TargetedLeftOuterJoin<ContactInterestTableInfo> LeftOuterJoin_ContactInterest_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<ContactInterestTableInfo>

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 .

LeftOuterJoin_CounterValue_ContactId

Generated left outer join from the primary key ContactId on this table, to CounterValue.ContactId.

Declaration

public TargetedLeftOuterJoin<CounterValueTableInfo> LeftOuterJoin_CounterValue_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<CounterValueTableInfo>

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 .

LeftOuterJoin_Email_ContactId

Generated left outer join from the primary key ContactId on this table, to Email.ContactId.

Declaration

public TargetedLeftOuterJoin<EmailTableInfo> LeftOuterJoin_Email_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<EmailTableInfo>

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 .

LeftOuterJoin_EmailItem_ContactId

Generated left outer join from the primary key ContactId on this table, to EmailItem.ContactId.

Declaration

public TargetedLeftOuterJoin<EmailItemTableInfo> LeftOuterJoin_EmailItem_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<EmailItemTableInfo>

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 .

LeftOuterJoin_FormSubmission_ContactId

Generated left outer join from the primary key ContactId on this table, to FormSubmission.ContactId.

Declaration

public TargetedLeftOuterJoin<FormSubmissionTableInfo> LeftOuterJoin_FormSubmission_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<FormSubmissionTableInfo>

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 .

LeftOuterJoin_FreeTextIndex_ContactId

Generated left outer join from the primary key ContactId on this table, to FreeTextIndex.ContactId.

Declaration

public TargetedLeftOuterJoin<FreeTextIndexTableInfo> LeftOuterJoin_FreeTextIndex_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<FreeTextIndexTableInfo>

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 .

LeftOuterJoin_Invoice_CompanyId

Generated left outer join from the primary key ContactId on this table, to Invoice.CompanyId.

Declaration

public TargetedLeftOuterJoin<InvoiceTableInfo> LeftOuterJoin_Invoice_CompanyId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<InvoiceTableInfo>

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 .

LeftOuterJoin_InvoiceSum_CompanyId

Generated left outer join from the primary key ContactId on this table, to InvoiceSum.CompanyId.

Declaration

public TargetedLeftOuterJoin<InvoiceSumTableInfo> LeftOuterJoin_InvoiceSum_CompanyId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<InvoiceSumTableInfo>

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 .

LeftOuterJoin_OwnerContactLink_ContactId

Generated left outer join from the primary key ContactId on this table, to OwnerContactLink.ContactId.

Declaration

public TargetedLeftOuterJoin<OwnerContactLinkTableInfo> LeftOuterJoin_OwnerContactLink_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<OwnerContactLinkTableInfo>

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 .

LeftOuterJoin_Person_ContactId

Generated left outer join from the primary key ContactId on this table, to Person.ContactId.

Declaration

public TargetedLeftOuterJoin<PersonTableInfo> LeftOuterJoin_Person_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<PersonTableInfo>

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 .

LeftOuterJoin_ProjectMember_ContactId

Generated left outer join from the primary key ContactId on this table, to ProjectMember.ContactId.

Declaration

public TargetedLeftOuterJoin<ProjectMemberTableInfo> LeftOuterJoin_ProjectMember_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<ProjectMemberTableInfo>

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 .

LeftOuterJoin_Sale_ContactId

Generated left outer join from the primary key ContactId on this table, to Sale.ContactId.

Declaration

public TargetedLeftOuterJoin<SaleTableInfo> LeftOuterJoin_Sale_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SaleTableInfo>

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 .

LeftOuterJoin_SaleHist_ContactId

Generated left outer join from the primary key ContactId on this table, to SaleHist.ContactId.

Declaration

public TargetedLeftOuterJoin<SaleHistTableInfo> LeftOuterJoin_SaleHist_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SaleHistTableInfo>

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 .

LeftOuterJoin_SaleStakeholder_ContactId

Generated left outer join from the primary key ContactId on this table, to SaleStakeholder.ContactId.

Declaration

public TargetedLeftOuterJoin<SaleStakeholderTableInfo> LeftOuterJoin_SaleStakeholder_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SaleStakeholderTableInfo>

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 .

LeftOuterJoin_Satellite_ContactId

Generated left outer join from the primary key ContactId on this table, to Satellite.ContactId.

Declaration

public TargetedLeftOuterJoin<SatelliteTableInfo> LeftOuterJoin_Satellite_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SatelliteTableInfo>

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 .

LeftOuterJoin_SelectionMember_ContactId

Generated left outer join from the primary key ContactId on this table, to SelectionMember.ContactId.

Declaration

public TargetedLeftOuterJoin<SelectionMemberTableInfo> LeftOuterJoin_SelectionMember_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SelectionMemberTableInfo>

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 .

LeftOuterJoin_SShipmentAddr_ContactId

Generated left outer join from the primary key ContactId on this table, to SShipmentAddr.ContactId.

Declaration

public TargetedLeftOuterJoin<SShipmentAddrTableInfo> LeftOuterJoin_SShipmentAddr_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SShipmentAddrTableInfo>

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 .

LeftOuterJoin_StatusValue_ContactId

Generated left outer join from the primary key ContactId on this table, to StatusValue.ContactId.

Declaration

public TargetedLeftOuterJoin<StatusValueTableInfo> LeftOuterJoin_StatusValue_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<StatusValueTableInfo>

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 .

LeftOuterJoin_TargetAssignmentInfo_ContactId

Generated left outer join from the primary key ContactId on this table, to TargetAssignmentInfo.ContactId.

Declaration

public TargetedLeftOuterJoin<TargetAssignmentInfoTableInfo> LeftOuterJoin_TargetAssignmentInfo_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TargetAssignmentInfoTableInfo>

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 .

LeftOuterJoin_TargetRevisionHistory_ContactId

Generated left outer join from the primary key ContactId on this table, to TargetRevisionHistory.ContactId.

Declaration

public TargetedLeftOuterJoin<TargetRevisionHistoryTableInfo> LeftOuterJoin_TargetRevisionHistory_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TargetRevisionHistoryTableInfo>

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 .

LeftOuterJoin_Ticket_ContactId

Generated left outer join from the primary key ContactId on this table, to Ticket.ContactId.

Declaration

public TargetedLeftOuterJoin<TicketTableInfo> LeftOuterJoin_Ticket_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketTableInfo>

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 .

LeftOuterJoin_URL_ContactId

Generated left outer join from the primary key ContactId on this table, to URL.ContactId.

Declaration

public TargetedLeftOuterJoin<URLTableInfo> LeftOuterJoin_URL_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<URLTableInfo>

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 .

LeftOuterJoin_WorkflowInstance_ContactId

Generated left outer join from the primary key ContactId on this table, to WorkflowInstance.ContactId.

Declaration

public TargetedLeftOuterJoin<WorkflowInstanceTableInfo> LeftOuterJoin_WorkflowInstance_ContactId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<WorkflowInstanceTableInfo>

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 .

MotherId

Field 'mother_id' in table 'contact': Dictionary type FK, target: Contact, .NET type: Int32

Reserved

Declaration

public Int32FieldInfo MotherId { 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 .

MotherId_InnerJoin_Contact

Generated join from the foreign key MotherId in this table, to its target table ContactTableInfo.

Declaration

public TargetedInnerJoin<ContactTableInfo> MotherId_InnerJoin_Contact { get; }

Property Value

Type	Description
TargetedInnerJoin<ContactTableInfo>

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 .

Name

Field 'name' in table 'contact': Dictionary type String[220], .NET type: String

Contact name

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 .

Nomailing

Field 'nomailing' in table 'contact': Dictionary type Bool, .NET type: Int16

No mailings flags

Declaration

public UInt16FieldInfo Nomailing { get; }

Property Value

Type	Description
UInt16FieldInfo

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 .

Number1

Field 'number1' in table 'contact': Dictionary type String[50], .NET type: String

Alphanumeric user field

Declaration

public StringFieldInfo Number1 { 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 .

Number2

Field 'number2' in table 'contact': Dictionary type String[50], .NET type: String

Alphanumeric user field

Declaration

public StringFieldInfo Number2 { 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 .

OrgNr

Field 'orgNr' in table 'contact': Dictionary type String[50], .NET type: String

VAT number or similar

Declaration

public StringFieldInfo OrgNr { 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 .

Registered

Field 'registered' in table 'contact': Dictionary type UtcDateTime, .NET type: DateTime

Date registered

Declaration

public DateTimeFieldInfo Registered { 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 .

RegisteredAssociateId

Field 'registered_associate_id' in table 'contact': Dictionary type FK, target: Associate, .NET type: Int32

Registered by whom

Declaration

public Int32FieldInfo RegisteredAssociateId { 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 .

RegisteredAssociateId_InnerJoin_Associate

Generated join from the foreign key RegisteredAssociateId in this table, to its target table AssociateTableInfo.

Declaration

public TargetedInnerJoin<AssociateTableInfo> RegisteredAssociateId_InnerJoin_Associate { get; }

Property Value

Type	Description
TargetedInnerJoin<AssociateTableInfo>

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 .

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration

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 .

SoundEx

Field 'soundEx' in table 'contact': Dictionary type String[10], .NET type: String

What the name sounds like, for duplicate detection

Declaration

public StringFieldInfo SoundEx { 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 .

Source

Field 'source' in table 'contact': Dictionary type UShort, .NET type: Int16

How did we get this contact? For future integration needs

Declaration

public UInt16FieldInfo Source { get; }

Property Value

Type	Description
UInt16FieldInfo

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 .

SupportAssociateId

Field 'supportAssociateId' in table 'contact': Dictionary type FK, target: Associate, .NET type: Int32

Our contact, but for support context, not sales/primary contact

Declaration

public Int32FieldInfo SupportAssociateId { 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 .

SupportAssociateId_InnerJoin_Associate

Generated join from the foreign key SupportAssociateId in this table, to its target table AssociateTableInfo.

Declaration

public TargetedInnerJoin<AssociateTableInfo> SupportAssociateId_InnerJoin_Associate { get; }

Property Value

Type	Description
TargetedInnerJoin<AssociateTableInfo>

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 .

SupportLanguageId

Field 'supportLanguageId' in table 'contact': Dictionary type FK, target: CustLang, .NET type: Int32

Customers language (does not necessarily map to ISO languages)

Declaration

public Int32FieldInfo SupportLanguageId { 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 .

SupportLanguageId_InnerJoin_CustLang

Generated join from the foreign key SupportLanguageId in this table, to its target table CustLangTableInfo.

Declaration

public TargetedInnerJoin<CustLangTableInfo> SupportLanguageId_InnerJoin_CustLang { get; }

Property Value

Type	Description
TargetedInnerJoin<CustLangTableInfo>

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 .

SupportPersonId

Field 'supportPersonId' in table 'contact': Dictionary type FK, target: Person, .NET type: Int32

The person (at the customer) who support talks to (the counterpart of supportAssociateId)

Declaration

public Int32FieldInfo SupportPersonId { 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 .

SupportPersonId_InnerJoin_Person

Generated join from the foreign key SupportPersonId in this table, to its target table PersonTableInfo.

Declaration

public TargetedInnerJoin<PersonTableInfo> SupportPersonId_InnerJoin_Person { get; }

Property Value

Type	Description
TargetedInnerJoin<PersonTableInfo>

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 .

TextId

Field 'text_id' in table 'contact': Dictionary type FK, target: Text, .NET type: Int32

Paperclip note

Declaration

public Int32FieldInfo TextId { 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 .

TextId_InnerJoin_Text

Generated join from the foreign key TextId in this table, to its target table TextTableInfo.

Declaration

public TargetedInnerJoin<TextTableInfo> TextId_InnerJoin_Text { get; }

Property Value

Type	Description
TargetedInnerJoin<TextTableInfo>

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 .

TicketPriorityId

Field 'ticketPriorityId' in table 'contact': Dictionary type FK, target: TicketPriority, .NET type: Int32

Default ticket priority for new tickets

Declaration

public Int32FieldInfo TicketPriorityId { 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 .

TicketPriorityId_InnerJoin_TicketPriority

Generated join from the foreign key TicketPriorityId in this table, to its target table TicketPriorityTableInfo.

Declaration

public TargetedInnerJoin<TicketPriorityTableInfo> TicketPriorityId_InnerJoin_TicketPriority { get; }

Property Value

Type	Description
TargetedInnerJoin<TicketPriorityTableInfo>

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 .

TzLocationId

Field 'tzLocationId' in table 'contact': Dictionary type FK, target: TZLocation, .NET type: Int32

Default timezone location for this contact

Declaration

public Int32FieldInfo TzLocationId { 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 .

TzLocationId_InnerJoin_TZLocation

Generated join from the foreign key TzLocationId in this table, to its target table TZLocationTableInfo.

Declaration

public TargetedInnerJoin<TZLocationTableInfo> TzLocationId_InnerJoin_TZLocation { get; }

Property Value

Type	Description
TargetedInnerJoin<TZLocationTableInfo>

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 .

Updated

Field 'updated' in table 'contact': Dictionary type UtcDateTime, .NET type: DateTime

Date last updated

Declaration

public DateTimeFieldInfo Updated { 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 .

UpdatedAssociateId

Field 'updated_associate_id' in table 'contact': Dictionary type FK, target: Associate, .NET type: Int32

Last updated by whom

Declaration

public Int32FieldInfo UpdatedAssociateId { 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 .

UpdatedAssociateId_InnerJoin_Associate

Generated join from the foreign key UpdatedAssociateId in this table, to its target table AssociateTableInfo.

Declaration

public TargetedInnerJoin<AssociateTableInfo> UpdatedAssociateId_InnerJoin_Associate { get; }

Property Value

Type	Description
TargetedInnerJoin<AssociateTableInfo>

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 .

UpdatedCount

Field 'updatedCount' in table 'contact': Dictionary type UShort, .NET type: Int16

Number of times updated

Declaration

public UInt16FieldInfo UpdatedCount { get; }

Property Value

Type	Description
UInt16FieldInfo

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 .

Userdef2Id

Field 'userdef2_id' in table 'contact': Dictionary type FK, target: UDContactLarge, .NET type: Int32

User defined table record 2

Declaration

public Int32FieldInfo Userdef2Id { 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 .

Userdef2Id_InnerJoin_UDContactLarge

Generated join from the foreign key Userdef2Id in this table, to its target table UDContactLargeTableInfo.

Declaration

public TargetedInnerJoin<UDContactLargeTableInfo> Userdef2Id_InnerJoin_UDContactLarge { get; }

Property Value

Type	Description
TargetedInnerJoin<UDContactLargeTableInfo>

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 .

UserdefId

Field 'userdef_id' in table 'contact': Dictionary type FK, target: UDContactSmall, .NET type: Int32

User defined table record 1

Declaration

public Int32FieldInfo UserdefId { 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 .

UserdefId_InnerJoin_UDContactSmall

Generated join from the foreign key UserdefId in this table, to its target table UDContactSmallTableInfo.

Declaration

public TargetedInnerJoin<UDContactSmallTableInfo> UserdefId_InnerJoin_UDContactSmall { get; }

Property Value

Type	Description
TargetedInnerJoin<UDContactSmallTableInfo>

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 .

Xstop

Field 'xstop' in table 'contact': Dictionary type Bool, .NET type: Int16

STOP flag

Declaration

public UInt16FieldInfo Xstop { get; }

Property Value

Type	Description
UInt16FieldInfo

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 .

Methods

IdxName(String)

Shortcut method for looking up using the database index Name, which spans the following fields:

Field	Description
Name	Contact name

Declaration

public Restriction IdxName(string name)

Parameters

Type	Name	Description
String	name

Returns

Type	Description
Restriction

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 .

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)