DBTable Class

A table that stores a persistent object‘s data.

Namespace: DevExpress.Xpo.DB

Assembly: DevExpress.Data.v18.1.dll

Declaration

C#

public class DBTable

VB.NET

Public Class DBTable

Related API Members

The following members accept/return DBTable objects:

• InMemoryDataStore.GetTableSchema(String)
• XPClassInfo.Table

Remarks

When saving a persistent object for the first time (or calling the Session.UpdateSchema method), XPO collects the list of persistent types corresponding to these objects and creates all required tables (DBTable objects) with the specified data relations between them.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the DBTable 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#L23

class CustomDBSchemaProvider : IDBSchemaProviderEx {
    DBTable[] tables;
    public void LoadColumns(SqlDataConnection connection, params DBTable[] tables) {

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

class CustomDBSchemaProvider : IDBSchemaProviderEx {
    DBTable[] tables;
    public void LoadColumns(SqlDataConnection connection, params DBTable[] tables) {

XAF_how-to-prevent-altering-the-legacy-database-schema-when-creating-an-xaf-application-e1150/CS/WinWebSolution.Module/XpoDataStoreProxy.cs#L86

}
public UpdateSchemaResult UpdateSchema(bool dontCreateIfFirstTableNotExist, params DBTable[] tables) {
    List<DBTable> db1Tables = new List<DBTable>();

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

ConnectionProviderSql provider = (ConnectionProviderSql)dataLayer.ConnectionProvider;
DBTable[] tables = provider.GetStorageTables("Products");
gridControl2.DataSource = new XPCollection(session1, Program.AddClass(session1.Dictionary, tables[0]));

XPO_how-to-use-custom-sql-queries-as-a-data-source-in-xpo-via-common-table-expressions-cte-e3468/CS/MsSqlWithCte.cs#L110

}
protected override UpdateSchemaResult ProcessUpdateSchema(bool skipIfFirstTableNotExists, params DBTable[] tables) {
    List<DBTable> realTables = new List<DBTable>(tables.Length);

VB.NET

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

Private tables() As DBTable
Public Sub LoadColumns(ByVal connection As SqlDataConnection, ParamArray ByVal tables() As DBTable) _

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

Private tables() As DBTable
Public Sub LoadColumns(ByVal connection As SqlDataConnection, ParamArray ByVal tables() As DBTable) _

XAF_how-to-prevent-altering-the-legacy-database-schema-when-creating-an-xaf-application-e1150/VB/WinWebSolution.Module/XpoDataStoreProxy.vb#L87

End Function
Public Function UpdateSchema(ByVal dontCreateIfFirstTableNotExist As Boolean, ByVal ParamArray tables() As DBTable) As UpdateSchemaResult Implements IDataStore.UpdateSchema
    Dim db1Tables As New List(Of DBTable)()

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

Dim provider As ConnectionProviderSql = CType(dataLayer.ConnectionProvider, ConnectionProviderSql)
Dim tables() As DBTable = provider.GetStorageTables("Products")
gridControl2.DataSource = New XPCollection(session1, Program.AddClass(session1.Dictionary, tables(0)))

XPO_how-to-use-custom-sql-queries-as-a-data-source-in-xpo-via-common-table-expressions-cte-e3468/VB/MsSqlWithCte.vb#L119

End Function
Protected Overrides Function ProcessUpdateSchema(ByVal skipIfFirstTableNotExists As Boolean, ParamArray ByVal tables() As DBTable) As UpdateSchemaResult
    Dim realTables As New List(Of DBTable)(tables.Length)

Inheritance

Object

DBTable