asp.net 多数据库支持的思考

　　<connectionStrings>

　　<add name="MyCmsConnectionString" connectionString="server=(local);user id=sa;pwd=123456;database=mycms;"/>

　　</connectionStrings>

　　using System;

　　using System.Collections.Generic;

　　using System.Text;

　　using System.Configuration;

　　using System.Data;

　　using System.Data.Common;

　　namespace COMMON

　　{

　　public class Class1

　　{

　　public DbConnection GetDatabaseConnection()

　　{

　　ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings["Conn"];

　　DbProviderFactory factory = DbProviderFactories.GetFactory(settings.ProviderName);

　　DbConnection conn = factory.CreateConnection();

　　conn.ConnectionString = settings.ConnectionString;

　　return conn;

　　}

　　}

　　}