How to: Connect XPO to a Database Other than MS SQL or MS Access
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:
Shared Sub Main()
Dim conn As String = DevExpress.Xpo.DB.MySqlConnectionProvider.GetConnectionString( _
"ServerName", "UserName", "Password", "DatabaseName")
XpoDefault.DataLayer = XpoDefault.GetDataLayer(conn, AutoCreateOption.DatabaseAndSchema)