OleDbConnection.Provider Property

 

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

Namespace:   System.Data.OleDb
Assembly:  System.Data (in System.Data.dll)

[BrowsableAttribute(true)]
public string Provider { get; }

Property Value

Type: System.String

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

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

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.
    }
}

.NET Framework
Available since 1.1
Return to top
Show: