How to: Connect XPO to a Database Other than Microsoft SQL or Microsoft Access

• Dec 28, 2022

XPO supports a number of database engines, all of which are listed in Database Systems Supported by XPO, together with corresponding XPO data store adapters and database provider assemblies. The adapter assembly name contains the server name it supports. For example, DevExpress.Xpo.Advantage supports the Advantage database, DevExpress.Xpo.Ase supports Sybase, etc.

 

To make XPO use your database server, you should do the following:

• Add the assemblies that correspond to your server to your project’s References.
• Create a connection string using the GetConnectionString function of the appropriate ConnectionProvider class from the DevExpress.Xpo.DB namespace.
• Connect XPO to a database.

Example: Connecting to MySql Database

Create a connection to your MySql database, as shown below:

C#

static void Main() {
    string conn = DevExpress.Xpo.DB.MySqlConnectionProvider.GetConnectionString(
        "ServerName", "UserName", "Password", "DatabaseName");
    XpoDefault.DataLayer = XpoDefault.GetDataLayer(conn, AutoCreateOption.DatabaseAndSchema);
    Application.Run(new MainForm());
}

VB.NET

Shared Sub Main()
    Dim conn As String = DevExpress.Xpo.DB.MySqlConnectionProvider.GetConnectionString( _
    "ServerName", "UserName", "Password", "DatabaseName")
    XpoDefault.DataLayer = XpoDefault.GetDataLayer(conn, AutoCreateOption.DatabaseAndSchema)
    Application.Run(New MainForm())
End Sub