How to: Connect XPO to a Database

• Jan 18, 2019

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, and so on.

 

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#

string conn = DevExpress.Xpo.DB.MySqlConnectionProvider.GetConnectionString(
    "ServerName", "UserName", "Password", "DatabaseName");
XpoDefault.DataLayer = XpoDefault.GetDataLayer(conn, AutoCreateOption.DatabaseAndSchema);

VB.NET

Dim conn As String = DevExpress.Xpo.DB.MySqlConnectionProvider.GetConnectionString( _
"ServerName", "UserName", "Password", "DatabaseName")
XpoDefault.DataLayer = XpoDefault.GetDataLayer(conn, AutoCreateOption.DatabaseAndSchema)