DatabaseTargetDBProvider Property

public string DBProvider { get; set; }

Public Property DBProvider As String
	Get
	Set

Dim instance As DatabaseTarget
Dim value As String

value = instance.DBProvider

instance.DBProvider = value

member DBProvider : string with get, set

Property Value

The parameter name should be a provider invariant name as registered in machine.config or app.config. Common values are:

• System.Data.SqlClient - SQL Sever Client
• System.Data.SqlServerCe.3.5 - SQL Sever Compact 3.5
• System.Data.OracleClient - Oracle Client from Microsoft (deprecated in .NET Framework 4)
• Oracle.DataAccess.Client - ODP.NET provider from Oracle
• System.Data.SQLite - System.Data.SQLite driver for SQLite
• Npgsql - Npgsql driver for PostgreSQL
• MySql.Data.MySqlClient - MySQL Connector/Net

(Note that provider invariant names are not supported on .NET Compact Framework).

Alternatively the parameter value can be be a fully qualified name of the provider connection type (class implementing IDbConnection) or one of the following tokens:

• sqlserver, mssql, microsoft or msde - SQL Server Data Provider
• oledb - OLEDB Data Provider
• odbc - ODBC Data Provider

Reference