MSSqlConnectionProvider(IDbConnection, AutoCreateOption) Constructor

Initializes a new instance of the MSSqlConnectionProvider class with the specified settings.

Namespace: DevExpress.Xpo.DB

Assembly: DevExpress.Xpo.v24.1.dll

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

NuGet Package: DevExpress.Xpo

Declaration

C#

public MSSqlConnectionProvider(
    IDbConnection connection,
    AutoCreateOption autoCreateOption
)

VB.NET

Public Sub New(
    connection As IDbConnection,
    autoCreateOption As AutoCreateOption
)

Parameters

Name	Type	Description
connection	IDbConnection	An object implementing the IDbConnection interface that represents an open connection to a data source.
autoCreateOption	AutoCreateOption	An AutoCreateOption value that specifies which operations are performed when storage is accessed for the first time. This parameter is used to initialize the IDataStore.AutoCreateOption property.

Remarks

Usually a Session object creates a connection provider manually based on the information supplied by the connection string. There are also cases when you need to create the connection provider manually via its constructor, for instance:

• when sharing a single IDataLayer object between multiple sessions. A connection provider should be passed to the data layer’s constructor. See the IDataLayer topic for additional information.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the MSSqlConnectionProvider(IDbConnection, AutoCreateOption) constructor.

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.

VB.NET

XPO_how-to-use-custom-sql-queries-as-a-data-source-in-xpo-via-common-table-expressions-cte-e3468/VB/S138124/MsSqlWithCte.vb#L17

Public Sub New(ByVal connection As IDbConnection, ByVal autoCreateOption As AutoCreateOption)
    MyBase.New(connection, autoCreateOption)
End Sub