XpoDefault.GetDataLayer(String, AutoCreateOption) Method

Creates a data access layer.

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 IDataLayer GetDataLayer(
    string connectionString,
    AutoCreateOption defaultAutoCreateOption
)

VB.NET

Public Shared Function GetDataLayer(
    connectionString As String,
    defaultAutoCreateOption As AutoCreateOption
) As IDataLayer

Parameters

Name	Type	Description
connectionString	String	A connection string.
defaultAutoCreateOption	AutoCreateOption	Specifies whether XPO can create a database or update its schema.

Returns

Type	Description
IDataLayer	An IDataLayer object.

Remarks

If the value passed to the connectionString parameter is a reference to Data Store Service (URL), the method connects SimpleDataLayer to a Data Store Service client.

The GetDataLayer method throws CannotFindAppropriateConnectionProviderException in the following situations:

A connection string does not contain the XpoProvider attribute and XPO cannot infer the provider name from other attributes.	To get a fully qualified connection string, use the GetConnectionString method of a corresponding connection provider.
A connection string references a Data Store Service and a target platform is .NET Core.	To connect a .NET Core project to a Data Store Service, create and configure DataStoreClientAsync or CachedDataStoreClient. For additional information, see WCF Client in .NET Core.

Tip

Dispose of a data layer instance when it is no longer in use to release the resources it holds.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the GetDataLayer(String, AutoCreateOption) method.

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#

winforms-reporting-create-report-bound-to-xpobjectsource/CS/ORMDataModel1Code/ConnectionHelper.cs#L36

else {
    XpoDefault.DataLayer = XpoDefault.GetDataLayer(ConnectionString, autoCreateOption);
}

XPO_how-to-persist-metadata-e269/CS/Program.cs#L34

metadataStorage = XpoDefault.GetDataLayer(InMemoryDataStore.GetConnectionString(metadataFileName), AutoCreateOption.DatabaseAndSchema);
dataStorage = XpoDefault.GetDataLayer(AccessConnectionProvider.GetConnectionString(dataFileName), AutoCreateOption.DatabaseAndSchema);

XPO_how-to-generate-a-sequential-number-for-a-business-object-within-a-database-transaction-e2620/CS/ExplicitUnitOfWorkDemo/Program.cs#L21

XpoDefault.Session = null;
XpoDefault.DataLayer = DatabaseHelper.DataLayer = XpoDefault.GetDataLayer(cs, DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema);
DatabaseHelper.SequenceDataLayer = XpoDefault.GetDataLayer(cs, DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema);

CriteriaOperatorsCheatSheet/CS/CriteriaOperatorCheatSheet/ConnectionHelper.cs#L39

} else {
    XpoDefault.DataLayer = XpoDefault.GetDataLayer(ConnectionString, autoCreateOption);
}

XPO_how-to-filter-an-associated-collection-in-legacy-xpo-versions-e876/CS/Program.cs#L22

    string conn = MSSqlConnectionProvider.GetConnectionString("(local)", "Northwind");
    XpoDefault.DataLayer = XpoDefault.GetDataLayer(conn, AutoCreateOption.SchemaAlreadyExists);
}

VB.NET

winforms-reporting-create-report-bound-to-xpobjectsource/VB/ORMDataModel1Code/ConnectionHelper.vb#L36

Else
    XpoDefault.DataLayer = XpoDefault.GetDataLayer(ConnectionString, autoCreateOption)
End If

XPO_how-to-persist-metadata-e269/VB/Program.vb#L38

metadataStorage = XpoDefault.GetDataLayer(InMemoryDataStore.GetConnectionString(metadataFileName), AutoCreateOption.DatabaseAndSchema)
dataStorage = XpoDefault.GetDataLayer(AccessConnectionProvider.GetConnectionString(dataFileName), AutoCreateOption.DatabaseAndSchema)

XPO_how-to-generate-a-sequential-number-for-a-business-object-within-a-database-transaction-e2620/VB/ExplicitUnitOfWorkDemo/Program.vb#L23

'ORIGINAL LINE: XpoDefault.DataLayer = DatabaseHelper.DataLayer = XpoDefault.GetDataLayer(cs, DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema);
            DatabaseHelper.DataLayer = XpoDefault.GetDataLayer(cs, DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema)
            XpoDefault.DataLayer = DatabaseHelper.DataLayer

XPO_how-to-filter-an-associated-collection-in-legacy-xpo-versions-e876/VB/Program.vb#L25

    Dim conn As String = MSSqlConnectionProvider.GetConnectionString("(local)", "Northwind")
    XpoDefault.DataLayer = XpoDefault.GetDataLayer(conn, AutoCreateOption.SchemaAlreadyExists)
End Sub

wpf-data-grid-in-server-mode-with-xpo/VB/XpoNorthwindServerMode/Window1.xaml.vb#L16

Dim conn As String = MSSqlConnectionProvider.GetConnectionString("(local)", "NorthwindXpo")
XpoDefault.DataLayer = XpoDefault.GetDataLayer(conn, AutoCreateOption.SchemaAlreadyExists)
Me.InitializeComponent()