DBColumn Class

The schema of a column in a DBTable.

Namespace: DevExpress.Xpo.DB

Assembly: DevExpress.Data.v18.1.dll

Declaration

C#

public class DBColumn

VB.NET

Public Class DBColumn

Related API Members

The following members accept/return DBColumn objects:

• DBTable.GetColumn(String)
• JoinNode.GetColumn(String)

Related GitHub Examples

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

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#

winforms-dashboard-designer-how-to-customize-a-data-store-schema-for-sql-data-sources-e5051/CS/Dashboard_CustomSchemaProvider/Form1.cs#L27

if(table.Name == "Categories" && table.Columns.Count == 0) {
    DBColumn categoryIdColumn = new DBColumn { Name = "CategoryID" };
    table.AddColumn(categoryIdColumn);

aspnet-mvc-dashboard-how-to-customize-a-data-store-schema-for-sql-data-sources-t584271/CS/MvcDashboard_CustomSchemaProvider/App_Start/DashboardConfig.cs#L27

if (table.Name == "Categories" && table.Columns.Count == 0) {
    DBColumn categoryIdColumn = new DBColumn { Name = "CategoryID" };
    table.AddColumn(categoryIdColumn);

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

DBColumnType primaryColumnType = table.GetColumn(table.PrimaryKey.Columns[0]).ColumnType;
classInfo.CreateMember(table.PrimaryKey.Columns[0], DBColumn.GetType(primaryColumnType),
    new KeyAttribute(IsAutoGenerationSupported(primaryColumnType)));

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

winforms-dashboard-designer-how-to-customize-a-data-store-schema-for-sql-data-sources-e5051/VB/Dashboard_CustomSchemaProvider/Form1.vb#L32

If table.Name = "Categories" AndAlso table.Columns.Count = 0 Then
    Dim categoryIdColumn As DBColumn = New DBColumn With {.Name = "CategoryID"}
    table.AddColumn(categoryIdColumn)

aspnet-mvc-dashboard-how-to-customize-a-data-store-schema-for-sql-data-sources-t584271/VB/MvcDashboard_CustomSchemaProvider/App_Start/DashboardConfig.vb#L34

If table.Name = "Categories" AndAlso table.Columns.Count = 0 Then
    Dim categoryIdColumn As DBColumn = New DBColumn With {.Name = "CategoryID"}
    table.AddColumn(categoryIdColumn)

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

Dim primaryColumnType As DBColumnType = table.GetColumn(table.PrimaryKey.Columns(0)).ColumnType
classInfo.CreateMember(table.PrimaryKey.Columns(0), DBColumn.GetType(primaryColumnType), New KeyAttribute(IsAutoGenerationSupported(primaryColumnType)))
For Each col As DBColumn In table.Columns

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

Inheritance

Object

DBColumn