.NET EF6实现适配多种数据库

最新推荐文章于 2024-07-09 16:16:41 发布

转载最新推荐文章于 2024-07-09 16:16:41 发布 · 773 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/zhanghuang/p/11352893.html

文章标签：

#数据库 #c#

本文详细介绍如何在配置文件中设置数据库信息，包括SQLServer和MySQL，并通过代码动态读取这些配置来创建数据库连接。此外，还展示了如何在DbContext子类中重写构造函数以使用动态获取的数据库连接。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.配置文件中添加数据库信息

<!--DBType value:SQLServer\MySQL-->
    <add key="DBType" value="MySQL"/>
    <!--数据库信息-->
    <add key="DataSource" value="."/>
    <add key="DB" value=""/>
    <add key="User" value=""/>
    <add key="Pwd" value=""/>

2.动态获取数据库信息

public class DBconfig 
    {
        private static readonly string dbType = System.Configuration.ConfigurationManager.AppSettings["DBType"];
        private static readonly string dataSource = System.Configuration.ConfigurationManager.AppSettings["DataSource"];
        private static readonly string db = System.Configuration.ConfigurationManager.AppSettings["DB"];
        private static readonly string user = System.Configuration.ConfigurationManager.AppSettings["User"];
        private static readonly string pwd = System.Configuration.ConfigurationManager.AppSettings["Pwd"];
        public static DbConnection GetConn()
        {
            if (dbType=="SQLServer")
            {
                System.Data.SqlClient.SqlConnectionStringBuilder sqlBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder();
                sqlBuilder.DataSource = dataSource;
                sqlBuilder.InitialCatalog = db;
                sqlBuilder.UserID = user;
                sqlBuilder.Password = pwd;
                sqlBuilder.PersistSecurityInfo = true;
                sqlBuilder.IntegratedSecurity = true;
                return new SqlConnection(sqlBuilder.ToString());               
                
            }
            else if(dbType=="MySQL")
            {
                MySql.Data.MySqlClient.MySqlConnectionStringBuilder sqlBuilder = new MySql.Data.MySqlClient.MySqlConnectionStringBuilder();
                sqlBuilder.Server = dataSource;
                sqlBuilder.Database = db;
                sqlBuilder.UserID = user;
                sqlBuilder.Password = pwd;

                return new MySqlConnection(sqlBuilder.ToString());
            }
            return null;
        }

3.重写DbContext子类的构造函数

public Entities() : base(DBconfig.GetConn(), true) { }

转载于:https://www.cnblogs.com/zhanghuang/p/11352893.html