log4net SDK Reference |

# AdoNetAppender.ConnectionType Property

Gets or sets the type name of the IDbConnection connection that should be created.

[Visual Basic]
Public Property ConnectionType As String
[C#]
public string ConnectionType {get; set;}

#### Property Value

The type name of the IDbConnection connection.

#### Remarks

The type name of the ADO.NET provider to use.

The default is to use the OLE DB provider.

#### Example

Use the OLE DB Provider. This is the default value.

    System.Data.OleDb.OleDbConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Use the MS SQL Server Provider.

    System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

Use the ODBC Provider.

    Microsoft.Data.Odbc.OdbcConnection,Microsoft.Data.Odbc,version=1.0.3300.0,publicKeyToken=b77a5c561934e089,culture=neutral

This is an optional package that you can download from http://msdn.microsoft.com/downloads search for ODBC .NET Data Provider. Use the Oracle Provider.

    System.Data.OracleClient.OracleConnection, System.Data.OracleClient, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

This is an optional package that you can download from http://msdn.microsoft.com/downloads search for .NET Managed Provider for Oracle.

#### See Also

AdoNetAppender Class | log4net.Appender Namespace