OleDbConnection.Provider Property

Definition

Namespace:

System.Data.OleDb

Assembly:

System.Data.OleDb.dll

Package:

System.Data.OleDb v10.0.0-preview.1.25080.5

Source:

OleDbConnection.cs

Gets the name of the OLE DB provider specified in the "Provider= " clause of the connection string.

C#

[System.ComponentModel.Browsable(true)]
public string Provider { get; }

Property Value

String

The name of the provider as specified in the "Provider= " clause of the connection string. The default value is an empty string.

Attributes

BrowsableAttribute

Examples

The following example creates an OleDbConnection and displays some of its read-only properties.

C#

static void OpenConnection(string connectionString)
{
    using (OleDbConnection connection = new OleDbConnection(connectionString))
    {
        try
        {
            connection.Open();
            Console.WriteLine("ServerVersion: {0} \nProvider: {1}",
                connection.ServerVersion, connection.Provider);
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }
        // The connection is automatically closed when the
        // code exits the using block.
    }
}

Applies to

See also

• Connecting to Data Sources