DBTable.Columns Property

Provides access to the current DBTable‘s column collection.

Namespace: DevExpress.Xpo.DB

Assembly: DevExpress.Data.v18.2.dll

Declaration

C#

public List<DBColumn> Columns { get; }

VB.NET

Public ReadOnly Property Columns As List(Of DBColumn)

Property Value

Type	Description
List<DBColumn>	A list of DBColumn objects that represent the columns defined in the current DBTable.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Columns property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

XPO_how-to-generate-persistent-metadata-for-an-arbitrary-data-table-e2922/CS/MapArbitraryDatabaseExample/Program.cs#L41

    new KeyAttribute(IsAutoGenerationSupported(primaryColumnType)));
foreach (DBColumn col in table.Columns)
    if (!col.IsKey && col.ColumnType != DBColumnType.Unknown)

XPO_how-to-generate-persistent-classes-at-runtime-based-on-a-dataset-e1198/CS/WindowsApplication4/Form1.cs#L27

string key = table.PrimaryKey.Columns[0];
foreach (DBColumn c in table.Columns)
{

VB.NET

XPO_how-to-generate-persistent-metadata-for-an-arbitrary-data-table-e2922/VB/MapArbitraryDatabaseExample/Program.vb#L45

classInfo.CreateMember(table.PrimaryKey.Columns(0), DBColumn.GetType(primaryColumnType), New KeyAttribute(IsAutoGenerationSupported(primaryColumnType)))
For Each col As DBColumn In table.Columns
    If (Not col.IsKey) AndAlso col.ColumnType <> DBColumnType.Unknown Then

XPO_how-to-generate-persistent-classes-at-runtime-based-on-a-dataset-e1198/VB/WindowsApplication4/Form1.vb#L26

Dim key As String = table.PrimaryKey.Columns(0)
For Each c As DBColumn In table.Columns
    Dim mi As XPMemberInfo = info.CreateMember(c.Name, DBColumn.GetType(c.ColumnType))