Syntax

Represents a Data Column definition. (D)

Remarks

The DbColumn object is used extensively throughout the LJC libraries, utilities and applications; wherever data elements need to be dynamically defined or manipulated. It is commonly used to define database table columns, grid control columns and text file columns and is often used to facilitate moving data between a database table column, grid control column, text file column or other data source and a data object.

A Data Object is an instance of a class that contains properties for each data element in a data source row. It is a strongly typed, object oriented representation of the data source row for use in code. It may contain common methods to assist with cloning, sorting and displaying an object string identifier.

When the ColumnName property is set, it will set the PropertyName property to the same value if PropertyName is null. This is the most common scenario where the data object property name is the same as the data source column name.

If a data object property name is different than the data source column name, then the PropertyName value must be set to the data object property name. For join columns, it may be the case that a different PropertyName needs to be chosen as there is already a property with that name. This often means that a RenameAs value must be assigned as there is most likely also a table column name conflict with the primary table.

8 Methods