XPO Data Source

• Mar 29, 2021
• 2 minutes to read

An XPO data source gets data from eXpress Persistent Objects.

Design Time

The XPO Data Source requires additional configuration to allow users to create the data source in a Data Source Wizard:

• Create a data layer to access a data store.
  In this example, a data layer (represented by the SimpleDataLayer class object) is created and assigned to the XpoDefault.DataLayer property using the XpoDefault.GetDataLayer method.

  C#

  using DevExpress.Data.DB;
  using DevExpress.Xpo;
  
  string forcedConnectionString = ...;
  XpoDefault.DataLayer = XpoDefault.GetDataLayer(forcedConnectionString, 
  AutoCreateOption.DatabaseAndSchema);
  

  VB.NET

  Imports DevExpress.Data.DB
  Imports DevExpress.Xpo
  
  Private forcedConnectionString As String =...
  XpoDefault.DataLayer = XpoDefault.GetDataLayer(forcedConnectionString, AutoCreateOption.DatabaseAndSchema)
  

• Create XPO classes:

  • Refer to the following topic for information how to create XPO classes in the Data Model Wizard: Data Model Wizard.
  • Refer to the following example for information how to create XPO classes in code: Create persistent classes and connect XPO to the database.

• Add the XPO value to the DashboardDesignerDataSourceWizardSettings.AvailableDataSourceTypes property to enable users to create the XPO data source. The XPO data source is added to the list of available data sources in the Data Source Wizard.

Tip

Documentation: Getting Started with XPO

Example on GitHub: How to Bind a Dashboard to the XPO Data Source at Design-Time

To connect to the pre-configured XPO data source, follow the steps below:

1. Click the New Data Source button in the Data Source ribbon tab.

   

2. On the first page of the invoked Data Source Wizard dialog, select eXpress Persistent Objects (XPO) and click Next. Then, specify the entity type.

   

   Select the Data Source Type

   

   Choose an Entity Type

Runtime

1. Create a DashboardXpoDataSource object and use the ConnectionStringName property to specify the name of the connection string defined in the application’s configuration file.

2. Pass the persistent object type to the SetEntityType method.

View Example: How to Bind a Dashboard to the XPO Data Source at Runtime

The code sample below illustrates how to connect to the XPO data source.

C#

using DevExpress.DashboardCommon;
// ...
public static DashboardXpoDataSource CreateXpoDataSource()
{
    DashboardXpoDataSource dataSource = new DashboardXpoDataSource()
    {
        ConnectionStringName = "northwind"
    };
    dataSource.SetEntityType(typeof(nwind.Customers));
    return dataSource;
}

VB.NET

Imports DevExpress.DashboardCommon
' ...
Public Shared Function CreateXpoDataSource() As DashboardXpoDataSource
  Dim dataSource As New DashboardXpoDataSource() With {.ConnectionStringName = "northwind"}
  dataSource.SetEntityType(GetType(nwind.Customers))
  Return dataSource
End Function