ADO.NET Database connection method
In MSDN, the .NET's database connection string has a detailed description, here in the way examples, the specificity of each representative can see the MSDN. ADO.NET Database connection
Microsoft provides the following four database connection methods:
System.data.oledb.oledbconnectionsystem.data.sqlclient.sqlconnectionsystem.data.odbc.odbcconnectionsystem.data.Oracleclient.OracleConnection
The following is an example-in way,
Some connection strings (C # code) common to System.Data.SqlClient.SqlConnection (C # code):
Sqlconnection conn = new sqlConnection ("Server = (local); integrated security = sspi; database = pubs");
SqlConnection conn = new sqlconnection ("Server = (local) // netsdk; database = pubs; integrated security = sspi");
SqlConnection conn = new sqlconnection ("data source = localhost; integrated security = sspi; initial catalog = northwind;");
SqlConnection conn = new sqlconnection ("data source = (local); INTEGRATED security = SSPI; persist security info = false; Workstation ID = xr; packet size = 4096;");
SqlConnection myconn = new system.data.sqlclient.sqlconnection ("PERSIST security info = false; integrated security = sspi; database = northwind; server = mysqlserver");
SqlConnection conn = new SQLCONNECTION ("UID = SA; PWD = Passwords; Initial Catalog = Pubs; Data Source = 127.0.0.1; connection timeout = 900");
More string connection notes See msdn: http://msdn.microsoft.com/library/default.asp? URL = / library / en-us / cpref / html / frsrfsystemDataSqlclientsqlConnectionClassConnectionstringtopic.asp
Some connection strings (C # code) commonly used by system.Data.oledb.oledbConnection (C # code):
OLEDBCONNECTION CONN = New OLEDBCONNECTION (@ "provider = microsoft.jet.oledb.4.0; data source = d: /myweb/81/05/grocertogo.mdb");
OleDbConnection conn = new OleDbConnection (@ "Provider = Microsoft.Jet.OLEDB.4.0; Password =; User ID = Admin; Data Source = grocertogo.mdb;"); OleDbConnection conn = new OleDbConnection ( "Provider = MSDAORA; Data Source = Oracle8i7; persist security info = false; integrated security = yes ");
OLEDBCONNECTION CONN = New OLEDBCONNECTION ("provider = microsoft.jet.Oledb.4.0; data source = c: /bin/localaccess40.mdb");
OLEDBCONNECTION CONN = New OLEDBCONNECTION ("provider = sqloledb; data source = mysqlserver; integrated security = SSPI");
More string connection instructions, please see MSDN: http://msdn.microsoft.com/library/default.asp? Url = / library / en-us / cpref / html / fr1rfsystemDataoledboledbconnectionclassconnectionstringtopic.asp? Frame = true
Some connection strings (C # code) common to System.Data.OracleClient.Data.OracleClient.OracleConnection: OracleConnection myconn = new system.data.OracleClient.Orcleconnection ("Data Source = ORACLE8I; Integrated Security = YES");
More string concatenation Description see MSDN: http: //msdn.microsoft.com/library/default.asp url = / library / en-us / cpref / html / frlrfSystemDataOracleClientOracleConnectionClassConnectionStringTopic.asp frame = true??
Some connection strings (C # code) commonly used system.data.odbc.odbcconnection:
OdbcConnection conn = new odbcconnection ("driver = {sql server}; server = myserver; trusted_connection = yes; data = northwind;");
Odbcconnection conn = new odbcconnection ("driver = {microsoft odbc for oracle}; server = Oracle8i7; Persist security info = false; trusted_connection = yes");
OdbcConnection conn = new odbcconnection ("driver = {Microsoft Access Driver (* .mdb)}; dbq = c: /bin/nwind.mdb");
OdbcConnection conn = new OdbcConnection ( "Driver = {Microsoft Excel Driver (* .xls)}; DBQ = c: /bin/book1.xls"); OdbcConnection conn = new OdbcConnection ( "Driver = {Microsoft Text Driver (* .txt ; * .csv)}; DBQ = C: / bin ");
OdbcConnection conn = new odbcconnection ("DSN = DSNNAME");
More string connection instructions, please see msdn: http://msdn.microsoft.com/library/default.asp? URL = / library / en-us / cpref / html / fr1rfsystemDataodBCODBCCCONNECLASSCONNECTIONSTRINGTOPIC.ASP? Frame = true
Database connection provided by other vendors:
DB2CONNECTION myconn = new ibm.data.db2.db2connection ("Database = Sample; UID =
; PWD =
");
DB2Connection myconn = new ibm.data.db2.db2connection ("Database = Sample");
BdpConnection myConn = new Borland.Data.Provider.BdpConnection ( "assembly = Borland.Data.Mssql, Version = 1.1.0.0, Culture = neutral, PublicKeyToken = 91d62ebb5b0d1b1b; vendorclient = sqloledb.dll; osauthentication = False; database =
Usernam
e =
Hostname =
Password =
"provider = mssql");
BdpConnection myConn = new Borland.Data.Provider.BdpConnection ( "assembly = Borland.Data.Db2, Version = 1.1.0.0, Culture = neutral, PublicKeyToken = 91d62ebb5b0d1b1b; vendorclient = db2cli.dll; database =
Username =
;
PASSWORD =
; provider = db2 ");
Connection Pooling
In the Data Provider in SQL Server, OLE DB, and .NET Framework, implicit connection pool connection support is provided. You can specify different parameter values to control the behavior of the connection pool in Connectionstring. For example, the following example makes the OLE DB connecting pool in effect and automatically transaction: provider = sqloledb; OLE DB Services = -4; Data Source = localhost; integrated security = SSPI; below SQL Server.net Data Provider Parameter Settings Control Connection Pool: Connection LiftTime, Connection Reset, Enlist, Max Pool Size, Min Pool Size and Pooling.
