XpoDefault.ConnectionString Property

Gets or sets the string which is used to open a database, by default.

Namespace: DevExpress.Xpo

Assembly: DevExpress.Xpo.v24.1.dll

NuGet Packages: DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap, DevExpress.Xpo

NuGet Package: DevExpress.Xpo

Declaration

C#

public static string ConnectionString { get; set; }

VB.NET

Public Shared Property ConnectionString As String

Property Value

Type	Description
String	A String value which specifies the parameters needed to establish the initial connection.

Remarks

Use the ConnectionString property to specify a connection string for the default Data Access Layer.

The default sessions and newly created sessions will use the specified connection string when they are connected to a data store, as shown in the following code example.

C#

using DevExpress.Xpo;
using DevExpress.Xpo.DB;

// Retrieve the Microsoft Access database-specific connection string.
XpoDefault.ConnectionString =
    AccessConnectionProvider.GetConnectionString("sample.mdb", "user", "pwd");
// If the default session is connected, disconnect it.
// XpoDefault.Session and Session.DefaultSession can be used interchangeably.
if(XpoDefault.Session.IsConnected) {
    XpoDefault.Session.Disconnect();
}

// The default data access layer is created and connected to the database
// using the connection string.
XpoDefault.Session.Connect();

VB.NET

Imports DevExpress.Xpo
Imports DevExpress.Xpo.DB

' Retrieve the Microsoft Access database-specific connection string.
XpoDefault.ConnectionString = _
AccessConnectionProvider.GetConnectionString("sample.mdb", "user", "pwd")
' If the default session is connected, disconnect it.
' XpoDefault.Session and Session.DefaultSession can be used interchangeably.
If XpoDefault.Session.IsConnected Then
    XpoDefault.Session.Disconnect()
End If

' The default data access layer is created and connected to the database
' using the connection string.
XpoDefault.Session.Connect()

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ConnectionString property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

XPO_how-to-implement-the-ivirtualtreelistdata-interface-in-xpo-e1601/CS/Q212620/Form1.cs#L15

public Form1() {
    XpoDefault.ConnectionString = AccessConnectionProvider.GetConnectionString(@"..\..\nwind.mdb");
    InitializeComponent();

winforms-filtercontrol-implement-ifilteredcomponent/CS/Q200298/Form1.cs#L19

public Form1() {
    XpoDefault.ConnectionString = AccessConnectionProvider.GetConnectionString(@"..\..\nwind.mdb");
    InitializeComponent();

winforms-grid-enable-server-mode-for-detail-view/CS/Q205267_4/Form1.cs#L18

public Form1() {
    XpoDefault.ConnectionString = AccessConnectionProvider.GetConnectionString(@"..\..\nwind.mdb");

winforms-treelist-expression-editor-xpview/CS/E1887/Program.cs#L16

static void Main() {
    XpoDefault.ConnectionString = InMemoryDataStore.GetConnectionString(@"..\..\data.xml");
    CreateData();

XPO_how-to-create-and-use-the-joinoperand-using-linq-to-xpo-and-criteria-operators-e1883/CS/E1883/Program.cs#L15

static void Main(string[] args) {
    XpoDefault.ConnectionString = MSSqlConnectionProvider.GetConnectionString("(local)", "E1883");
    CreateData();

VB.NET

XPO_how-to-implement-the-ivirtualtreelistdata-interface-in-xpo-e1601/VB/Q212620/Form1.vb#L14

Public Sub New()
    XpoDefault.ConnectionString = AccessConnectionProvider.GetConnectionString("..\..\nwind.mdb")
    InitializeComponent()

winforms-filtercontrol-implement-ifilteredcomponent/VB/Q200298/Form1.vb#L16

Public Sub New()
    XpoDefault.ConnectionString = AccessConnectionProvider.GetConnectionString("..\..\nwind.mdb")
    InitializeComponent()

winforms-grid-enable-server-mode-for-detail-view/VB/Q205267_4/Form1.vb#L16

Public Sub New()
    XpoDefault.ConnectionString = AccessConnectionProvider.GetConnectionString("..\..\nwind.mdb")
    ' Uncomment this code to create new database

winforms-treelist-expression-editor-xpview/VB/E1887/Program.vb#L17

Sub Main()
    XpoDefault.ConnectionString = InMemoryDataStore.GetConnectionString("..\..\data.xml")
    Call CreateData()

XPO_how-to-load-unique-distinct-data-via-xpo-e1001/VB/Distinct/Form1.vb#L146

Shared Sub Main()
    DevExpress.Xpo.XpoDefault.ConnectionString = DevExpress.Xpo.DB.MSSqlConnectionProvider.GetConnectionString(".\SQLEXPRESS", "Northwind")
    Application.Run(New Form1())