ado.net连接数据库:介绍几种 ADO.net 中的数据库连接方式来源: 发布时间:星期四, 2009年3月19日 浏览:0次 评论:0
="t18">
在MSDN中  .net 数据库连接 串都有具体介绍说明我这里以代码范例方式罗列 些具体每项代表意义可以参看MSDN. ADO.net 中数据库连接方式(微软提供) 微软提供了以下 4种数据库连接方式:  .Data.OleDb.OleDbConnection .Data.SqlClient.SqlConnection .Data.Odbc.OdbcConnection .Data.OracleClient.OracleConnection 下面我们以范例 方式来依次介绍说明: .Data.SqlClient.SqlConnection 常用 些连接串(C#代码): SqlConnection conn =  SqlConnection( "Server=(local);Integrated Security=SSPI;database=Pubs"); SqlConnection conn = SqlConnection("server=(local)\\NetSDK;database=pubs;Integrated Security=SSPI"); SqlConnection conn = SqlConnection( "Data Source=localhost;Integrated Security=SSPI;Initial Catalog=Northwind;"); SqlConnection conn = SqlConnection( " data source=(local);initial catalog=xr;  egrated security=SSPI; persist security info=False;workstation id=XURUI;packet size=4096; "); SqlConnection myConn = .Data.SqlClient.SqlConnection("Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mysqlServer"); SqlConnection conn = SqlConnection( " uid=sa;pwd=passWords;initial catalog=pubs;data source=127.0.0.1;Connect Timeout=900"); 更多 串连接介绍说明请看MSDN: http://msdn.microsoft.com/library/default.ASP?url=/library/en-us/cpref/Html/frlrf DataSqlClientSqlConnectionClassConnectionStringTopic.asp .Data.OleDb.OleDbConnection 常用 些连接串(C#代码): OleDbConnection conn = OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\MyWeb\81\05\GrocerToGo.mdb"); OleDbConnection conn = OleDbConnection( @"Provider=Microsoft.Jet.OLEDB.4.0;Password=; User ID=Admin;Data Source=grocertogo.mdb;"); OleDbConnection conn = OleDbConnection( "Provider=MSDAORA; Data Source=ORACLE8i7;Persist Security Info=False;Integrated Security=yes"); OleDbConnection conn = OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\bin\LocalAccess40.mdb"); OleDbConnection conn = OleDbConnection( "Provider=SQLOLEDB;Data Source=MySQLServer;Integrated Security=SSPI"); 更多 串连接介绍说明请看MSDN: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrf DataOleDbOleDbConnectionClassConnectionStringTopic.asp?frame=true .Data.OracleClient.OracleConnection 常用 些连接串(C#代码): OracleConnection myConn = .Data.OracleClient.OracleConnection( "Data Source=Oracle8i;Integrated Security=yes"); 更多 串连接介绍说明请看MSDN: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrf DataOracleClientOracleConnectionClassConnectionStringTopic.asp?frame=true .Data.Odbc.OdbcConnection 常用 些连接串(C#代码): OdbcConnection conn = OdbcConnection( "Driver={SQL Server};Server=MyServer;Trusted_Connection=yes;Database=Northwind;"); OdbcConnection conn = OdbcConnection( "Driver={Microsoft ODBC for Oracle};Server=ORACLE8i7; Persist Security Info=False;Trusted_Connection=yes"); OdbcConnection conn = OdbcConnection( "Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\bin\nwind.mdb"); OdbcConnection conn = OdbcConnection( "Driver={Microsoft Excel Driver (*.xls)};DBQ=c:\bin\book1.xls"); OdbcConnection conn = OdbcConnection( "Driver={Microsoft Text Driver (*.txt; *.csv)};DBQ=c:\bin"); OdbcConnection conn = OdbcConnection("DSN=dsnname"); 更多 串连接介绍说明请看MSDN: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrf DataOdbcOdbcConnectionClassConnectionStringTopic.asp?frame=true 其他厂商提供 数据库连接: DB2Connection myConn = IBM.Data.DB2.DB2Connection( "DATABASE = SAMPLE;UID=<username>; PWD=<password>;"); DB2Connection myConn = IBM.Data.DB2.DB2Connection("DATABASE = SAMPLE"); BdpConnection myConn = Borland.Data.Provider.BdpConnection("assembly=Borl and.Data.MSSQL,Version=1.1.0.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b;ve ndorclient=sqloledb.dll;osauthentication=False;database=<database>;usernam e=<user>;hostname=<host>;password=<password>;provider=MSSQL"); BdpConnection myConn = Borland.Data.Provider.BdpConnection("assembly=Borl and.Data.Db2,Version=1.1.0.0,Culture=neutral,PublicKeyToken=91d62ebb5b0d1b1b;ve ndorclient=db2cli.dll;database=<database>;username=<user>; password=<password>;provider=DB2"); Connection Pooling 在SQL Server、OLE DB和.NET框架结构中 Data Provider中都提供了隐式连接池连接支持 你可以在ConnectionString中指定区别 参数值控制连接池行为比如下面例子使OLE DB连接池无效并自动地进行事务处理: Provider=SQLOLEDB;OLE DB Services=-4;Data Source=localhost;Integrated Security=SSPI; 在SQL Server.NET Data Provider中提供了以下参数设置控制连接池 行为:Connection L ttime、Connection Re 、Enlist、Max Pool Size、Min Pool Size和Pooling 0
相关文章读者评论发表评论 |
 |
专注于互联网--专注于架构 |
最新标签 网站地图 文章索引 Rss订阅 |
