XpoDefault.GetConnectionProvider(String, AutoCreateOption) Method

Creates a data store provider (an IDataStore instance).

Namespace: DevExpress.Xpo

Assembly: DevExpress.Xpo.v21.1.dll

NuGet Package: DevExpress.Xpo

Declaration

C#

public static IDataStore GetConnectionProvider(
    string connectionString,
    AutoCreateOption defaultAutoCreateOption
)

VB.NET

Public Shared Function GetConnectionProvider(
    connectionString As String,
    defaultAutoCreateOption As AutoCreateOption
) As IDataStore

Parameters

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

Returns

Type	Description
IDataStore	A data store provider.

Remarks

The GetConnectionProvider method uses the ActiveConnectionString property if the connectionString parameter value is null (Nothing in Visual Basic).

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

The GetConnectionProvider 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 Standard or .NET Core.	To connect a .NET Standard/.NET Core project to a Data Store Service, create and configure DataStoreClientAsync or CachedDataStoreClient. For additional information, see WCF Client in .NET Core.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the GetConnectionProvider(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#

XPO_how-to-create-a-data-caching-service-that-helps-improve-performance-in-distributed-e4932/CS/WcfService2/Service1.svc.cs#L15

string connectionString = MSSqlConnectionProvider.GetConnectionString("localhost", "ServiceDB");
MSSqlConnectionProvider dataStore = (MSSqlConnectionProvider)XpoDefault.GetConnectionProvider(
            connectionString,

XAF_how-to-prevent-altering-the-legacy-database-schema-when-creating-an-xaf-application-e1150/CS/WinWebSolution.Module/XpoDataStoreProxy.cs#L37

}
legacyDataStore = XpoDefault.GetConnectionProvider(legacyConnectionString, AutoCreateOption.DatabaseAndSchema);
legacyDataLayer = new SimpleDataLayer(legacyDictionary, legacyDataStore);

Create-a-Report-Bound-To-XPObjectSource/CS/Create a Report Bound to XPObjectSource/ORMDataModel1Code/ConnectionHelper.cs#L30

if (threadSafe) {
    var provider = XpoDefault.GetConnectionProvider(ConnectionString, autoCreateOption);
    var dictionary = new DevExpress.Xpo.Metadata.ReflectionDictionary();

winforms-dashboard-xpo-data-source/CS/DashboardXpoExample/ORMDataModel1Code/ConnectionHelper.cs#L34

{
    var provider = XpoDefault.GetConnectionProvider(ConnectionString, autoCreateOption);
    var dictionary = new DevExpress.Xpo.Metadata.ReflectionDictionary();

XPO_how-to-implement-odata4-service-with-xpo/CS/ODataService/Helpers/ConnectionHelper.cs#L38

if(threadSafe) {
    var provider = XpoDefault.GetConnectionProvider(XpoDefault.GetConnectionPoolString(ConnectionString), autoCreationOption);
    return new ThreadSafeDataLayer(dictionary, provider);

VB.NET

XPO_how-to-create-a-data-caching-service-that-helps-improve-performance-in-distributed-e4932/VB/WcfService2/Service1.svc.vb#L13

Dim connectionString As String = MSSqlConnectionProvider.GetConnectionString("localhost", "ServiceDB")
Dim dataStore As MSSqlConnectionProvider = CType(XpoDefault.GetConnectionProvider(connectionString, AutoCreateOption.DatabaseAndSchema), MSSqlConnectionProvider)
Dim objectsToDispose() As IDisposable

XAF_how-to-prevent-altering-the-legacy-database-schema-when-creating-an-xaf-application-e1150/VB/WinWebSolution.Module/XpoDataStoreProxy.vb#L38

Next ci
legacyDataStore = XpoDefault.GetConnectionProvider(legacyConnectionString, AutoCreateOption.DatabaseAndSchema)
legacyDataLayer = New SimpleDataLayer(legacyDictionary, legacyDataStore)

Create-a-Report-Bound-To-XPObjectSource/VB/Create a Report Bound to XPObjectSource/ORMDataModel1Code/ConnectionHelper.vb#L35

If threadSafe Then
    Dim provider = XpoDefault.GetConnectionProvider(ConnectionString, autoCreateOption)
    Dim dictionary = New DevExpress.Xpo.Metadata.ReflectionDictionary()

winforms-dashboard-xpo-data-source/VB/DashboardXpoExample/ORMDataModel1Code/ConnectionHelper.vb#L34

If threadSafe Then
    Dim provider = XpoDefault.GetConnectionProvider(ConnectionString, autoCreationOption)
    Dim dictionary = New DevExpress.Xpo.Metadata.ReflectionDictionary()

XPO_tutorial-2-relations-one-to-many-e4557/VB/XpoTutorial2/MyDataModelCode/ConnectionHelper.vb#L23

Public Shared Function GetConnectionProvider(ByVal autoCreateOption As DevExpress.Xpo.DB.AutoCreateOption) As DevExpress.Xpo.DB.IDataStore
    Return XpoDefault.GetConnectionProvider(ConnectionString, autoCreateOption)
End Function