ConnectionProviderSql Class

Implements the base functionality for SQL-based data store adapters, including the MSSqlConnectionProvider and other adapters listed in the Database Systems Supported by XPO topic.

Namespace: DevExpress.Xpo.DB

Assembly: DevExpress.Data.v18.1.dll

Declaration

C#
VB.NET

public abstract class ConnectionProviderSql :
    DataStoreBase,
    ISqlGeneratorFormatterEx,
    ISqlGeneratorFormatterSupportSkipTake,
    ISqlGeneratorFormatterSupportOuterApply,
    ISqlGeneratorFormatter,
    ISqlDataStore,
    IDataStore,
    IDataStoreSchemaExplorerSp,
    IDataStoreSchemaExplorer,
    ICommandChannel

Public MustInherit Class ConnectionProviderSql
    Inherits DataStoreBase
    Implements ISqlGeneratorFormatterEx,
               ISqlGeneratorFormatterSupportSkipTake,
               ISqlGeneratorFormatterSupportOuterApply,
               ISqlGeneratorFormatter,
               ISqlDataStore,
               IDataStore,
               IDataStoreSchemaExplorerSp,
               IDataStoreSchemaExplorer,
               ICommandChannel

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

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#
VB.NET

XPO_how-to-generate-persistent-metadata-for-an-arbitrary-data-table-e2922/CS/MapArbitraryDatabaseExample/Form1.cs#L20

SimpleDataLayer dataLayer = (SimpleDataLayer)session1.DataLayer;
ConnectionProviderSql provider = (ConnectionProviderSql)dataLayer.ConnectionProvider;
DBTable[] tables = provider.GetStorageTables("Products");

XPO_how-to-implement-the-icustomfunctionoperatorformattable-interface-e2491/CS/Program.cs#L15

static void Main() {
    ConnectionProviderSql provider =
        (ConnectionProviderSql)XpoDefault.GetConnectionProvider(AccessConnectionProvider.GetConnectionString(@"..\..\CustomCommand.mdb"),

XPO_how-to-generate-persistent-metadata-for-an-arbitrary-data-table-e2922/VB/MapArbitraryDatabaseExample/Form1.vb#L22

Dim dataLayer As SimpleDataLayer = CType(session1.DataLayer, SimpleDataLayer)
Dim provider As ConnectionProviderSql = CType(dataLayer.ConnectionProvider, ConnectionProviderSql)
Dim tables() As DBTable = provider.GetStorageTables("Products")

XPO_how-to-implement-the-icustomfunctionoperatorformattable-interface-e2491/VB/Program.vb#L18

Shared Sub Main()
    Dim provider As ConnectionProviderSql = CType(XpoDefault.GetConnectionProvider(AccessConnectionProvider.GetConnectionString("..\..\CustomCommand.mdb"), AutoCreateOption.DatabaseAndSchema), ConnectionProviderSql)
    provider.RegisterCustomFunctionOperator(New GetMonthFunction())