[EntityDefinition(EntityID.ReconciliationSourceColumn, "dbo.LT_ReconciliationSourceColumns", "ReconciliationSourceColumn", IsStandingDataEntity = true)]
[DefaultEntityIcon(ImageType.DataTableColumn)]
public interface IReconciliationSourceColumn : IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties

Properties

ColumnID

[Key] Links to ISQLTypeWrapper. The sql wrapper column for this source

Declaration

[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityRelationship(EntityID.SQLTypeWrapper, "ID", SingleJoinType.ZeroToOne, "Column", "Reconciliation Source", DeleteWithRelationship = false, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false)]
Guid? ColumnID { get; set; }

Property Value

Type	Description
Guid?

ColumnName

The name of the column from a csv embedded file for this source

Declaration

[EntityProperty(SQLType.NVarChar, 500, true)]
string ColumnName { get; set; }

Property Value

Type	Description
string

ColumnType

The .net framework equivalent type of this csv column.

Declaration

[EntityProperty(SQLType.NVarChar, 500, true)]
[EntityDescription("The .net framework equivalent type of this csv column.")]
string ColumnType { get; set; }

Property Value

Type	Description
string

CompareToPrimaryColumnID

[Key] Links to ISQLTypeWrapper. The sql wrapper column from the primary source to compare to

Declaration

[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityRelationship(EntityID.SQLTypeWrapper, "ID", SingleJoinType.ZeroToOne, "Column", "Reconciliation Source", DeleteWithRelationship = false, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false)]
Guid? CompareToPrimaryColumnID { get; set; }

Property Value

Type	Description
Guid?

CompareToPrimaryColumnName

The name of the column from a csv embedded file from the primary source to compare to

Declaration

[EntityProperty(SQLType.NVarChar, true)]
string CompareToPrimaryColumnName { get; set; }

Property Value

Type	Description
string

IsKeyCol

Indicates this is the key column to be used for comparisons

Declaration

[EntityProperty(SQLType.Bit, false)]
[EntityDescription("Indicates this is the key column to be used for comparisons")]
bool IsKeyCol { get; set; }

Property Value

Type	Description
bool

Order

Indicates the order to apply for this column when comparing by order.

Declaration

[EntityProperty(SQLType.SmallInt, false)]
[EntityDescription("Indicates the order to apply for this column when comparing by order.")]
Order Order { get; set; }

Property Value

Type	Description
Order

ReconciliationID

[Key] Links to IReconciliation. The parent reconciliation this source column belongs to

Declaration

[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.Reconciliation, "ID", SingleJoinType.One, "Reconciliation", "Source Columns", DeleteWithRelationship = true, PartOfParentSet = true, LinkToItemInSet = false, InheritPermissions = true)]
[RequiredNoDefaultIDValidation]
[EntityKeyProperty]
Guid ReconciliationID { get; set; }

Property Value

Type	Description
Guid

ReconciliationSourceID

[Key] Links to IReconciliation. The parent reconciliation this source belongs to

Declaration

[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.ReconciliationSource, "ID", SingleJoinType.One, "Reconciliation Source", "Columns", DeleteWithRelationship = true, PartOfParentSet = true, LinkToItemInSet = false, InheritPermissions = false)]
[RequiredNoDefaultIDValidation]
[EntityKeyProperty]
Guid ReconciliationSourceID { get; set; }

Property Value

Type	Description
Guid

Sequence

[Key] The sequence specifies the order this column will be used in the source when order by is used

Declaration

[EntityProperty(SQLType.SmallInt, false, "0")]
[EntityDescription("The sequence specifies the order this column will be used in the source when order by is used.")]
[EntitySequence]
[EntityKeyProperty]
short Sequence { get; set; }

Property Value

Type	Description
short

Extension Methods

LinqExtensions.AsArray<T>(T)

LinqExtensions.ToArrayOfOne<T>(T)

LinqExtensions.ToListOfOne<T>(T)

MiscExtensions.SetIfNotEqual<T, TP>(T, Expression<Func<T, TP>>, TP)

WeakReferenceExtensions.WeakReference(object)

SQLExtensions.ToSQLValue(object, bool)

ReflectionExtensions.ClearEventInvocations(object, string)

StringExtensions.ToCSVFormatString(object, Type)