XpoProvider=MSSqlServer Data Source=(local) User ID=username Password=password Initial Catalog=database Persist Security Info=true XpoProvider=InMemoryDataStore Data Source=C:\mydatabase.xml Read Only=false XpoProvider=XmlDataSet Data Source=C:\mydatabase.xml Read Only=false XpoProvider=MSAccess Provider=.4.0 Data Source=C:\mydatabase.mdb User Id=admin Password= The list below contains the XpoProvider parameter values for all the supported connection providers:
You can specify an XPO provider type in a connection string using the XpoProvider parameter: XpoProvider=Provider name. Use this method if you can create a connection string in code. This method returns a connection string that contains the XpoProvider parameter.
How To Create a Correct Connection Stringīuilt-in connection providers have the public GetConnectionString method. XpoDefault.GetDataLayer(connectionString, AutoCreateOption.DatabaseAndSchema) ĭim connectionString = MySqlConnectionProvider.GetConnectionString("DBSERVER", "user", _ĭim dataLayer As IDataLayer = XpoDefault.GetDataLayer(connectionString, _ MySqlConnectionProvider.GetConnectionString("DBSERVER", "user", "pwd", "MyApp")
Then you can use the following code to create a connection to the database. To connect to the MySql database, add the MySql.Data assembly to your project’s References. Refer to How to: Connect to a Data Store for complete information on how to connect to a data store. Generally, this can be done either by specifying the connection settings of the XpoDefault (via the XpoDefault.ConnectionString or XpoDefault.DataLayer properties) and using the Session.DefaultSession or creating your Session object, or by assigning the Session.ConnectionString or Session.Connection properties of a session.
MS SQL Server 2000 Desktop Engine (MSDE 2000) PostgreSQL 7, PostgreSQL 8, PostgreSQL 9, PostgreSQL 10, PostgreSQL 11, PostgreSQL 12 Oracle 9i, Oracle 10g, Oracle 11g, Oracle 12c, Oracle 18c MySQL Server 5.0, MySQL Server 5.1, MySQL Server 5.7, MySQL Server 8.0.12 SQL Server 2005 Express Edition, SQL Server 2008, SQL Azure™ Database, SQL Server 2008 R2, SQL Server 2008 R2 Express, SQL Server 2012, SQL Server 2012 Express (including LocalDB), SQL Server 2014, SQL Server 2014 Express (including LocalDB), SQL Server 2016, SQL Server 2016 Express (including LocalDB), SQL Server 2017 Microsoft SqlServer 7.0, Microsoft SqlServer 2000, MS SQL Server 2000 Desktop Engine (MSDE 2000), Microsoft SQL Server 2005,