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>
<add key="SQLConnString" value="provider=microsoft.jet.oledb.4.0;Password=Admin;
User ID=Admin;data source="/>
<add key="dbPath" value="~/App_Data/mydata.mdb"/>
</appSettings>
程序中：数据访问类中把"SQLConnString"和"dbPath"取出来连接成一个字符串"CONN_STRING_NON_DTC"
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>
方法(2):<connectionStrings>
<add name="SQLConnString" connectionString="Server=localhost;
Integrated Security=True;Database=pubs;Persist Security Info=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 Security=SSPI;uid=sa;pwd=passwords;Initial Catalog=Pubs;"/>
</appSettings>
SqlServer通用接口:
<appSettings>
    <add key="SQLConnection" value="Provider=SQLOLEDB;User Id=sa;Password=office;Initial    Catalog=office;server=localhost;"/>
</appSettings>
Oracle通用接口:
方法(1):<appSettings>
    <add key="ORACLEConnectionString" value="Provider=OraOLEDB.Oracle.1;
Persist Security Info=False;Password=blah;User ID=greg;Data Source=sph;" /> 
<appSettings>
方法(2):
<appSettings>
    <add key="ORACLEConnectionString" value="Provider=MSDAORA;Password=tiger;User ID=scott; Data Source=sph;Persist Security Info=False;Integrated Security=yes" /> 
<appSettings>
OracleClient:
<appSettings>  
    <add key="ConnectionString" value="Data Source=testDB;User ID=scott;Password=tiger;" />  </appSettings>