DBTable.Columns Property

Provides access to the current DBTable‘s column collection.

Namespace: DevExpress.Xpo.DB

Assembly: DevExpress.Data.v24.1.dll

NuGet Package: DevExpress.Data

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#

XAF-How-to-Implement-CRUD-Operations-for-Non-Persistent-Objects-Stored-Remotely/CS/NonPersistentObjectsDemo.Module/DataStoreMapper.cs#L59

statement.Condition = dbCriteria;
foreach(var column in mapping.Table.Columns) {
    statement.Operands.Add(new QueryOperand(column, alias));

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)
{

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

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

VB.NET

XAF-How-to-Implement-CRUD-Operations-for-Non-Persistent-Objects-Stored-Remotely/VB/NonPersistentObjectsDemo.Module/DataStoreMapper.vb#L56

statement.Condition = dbCriteria
For Each column In mapping.Table.Columns
    statement.Operands.Add(New QueryOperand(column, [alias]))

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))