ASP[1].NET连接ACCESS、SqlServer以及Oracle数据库的web.config内路径最优写法

ASP.NET 连接 ACCESS、SqlServer 以及 Oracle 数据库的 web.config 内路径最优写法

net 中提供了四种数据库连接方式：

System.Data.OleDb.OleDbConnection

System.Data.SqlClient.SqlConnection

System.Data.Odbc.OdbcConnection

System.Data.OracleClient.OracleConnection

ACCESS:

<appSettings>

public static readonly string CONN_STRING_NON_DTC =

System.Configuration.ConfigurationManager.AppSettings["SQLConnString"].ToString() +

System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbPath"])

+ ";";

SqlClient:

方法(1):<connectionStrings>

<add name="SQLConnString" connectionString="Data Source=localhost;Integrated

Security=True;AttachDbFilename=|DataDirectory|pubs.mdf;User Instance=True"

providerName="System.Data.SqlClient"/>

</connectionStrings>

要 using System.Data.SqlClient;

string connectionString

=ConfigurationManager.ConnectionStrings["SQLConnString"].ConnectionString;

SqlServer 专属接口:

方法(1):<appSettings>

<add key="SQLConnection" value="Server=(local);Integrated

Security=SSPI;database=Pubs"/>

</appSettings>

方法(2):<appSettings>

<add key="SQLConnection" value="Data Source=localhost;Integrated