public DbNetData(
	string ConnectionString
)

Public Sub New ( _
	ConnectionString As String _
)

public:
DbNetData(
	String^ ConnectionString
)

The provider is derived on the following basis:

• If the connection string matches the regular expression "Provider=.*oledb.*;" then the OleDb data provider is used
• If the connection string matches the regular expression "dsn=.*" then the Odbc data provider is used
• If the connection string matches the regular expression "Data Source=(.*)\.vdb3;" then the VistaDB data provider is used
• If the connection string matches the regular expression "Data Source=(.*)\.fdb;" then the Firebird data provider is used
• If the connection string matches none of the above then the SqlClient data provider is used

Provider information can also be supplied in the connection string as an additional property called DataProvider specifying one of the supported Data providers

CopyC#

DbNetData Db = new DbNetData("Server=dbserver;Database=Northwind;Trusted_Connection=true;");

CopyC#

DbNetData Db = new DbNetData("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\data\hr.mdb");

CopyC#

// Speciying the data provider in the connection string
DbNetData Db = new DbNetData("Data Source=Employees;user id=scott;password=tiger;DataProvider=OracleClient;");

CopyC#

// You can also simply provide the key for a <connectionStrings> entry in the web.config entry
DbNetData Db = new DbNetData("nwind");