C# Code First 和 DB First 加密连接字符串

最新推荐文章于 2024-04-03 14:25:41 发布

Weber_t

最新推荐文章于 2024-04-03 14:25:41 发布

阅读量390

点赞数

本文链接：https://blog.csdn.net/weirtang/article/details/89368110

版权

        /// <summary>
        /// DB First 获取连接字符串
        /// </summary>
        public ClientEntities()
            : base("name=ClientEntities")
        {
           base.Database.Connection.ConnectionString = AppConfig.DataBaseConnectionString();
        }
        /// <summary>
        /// Code First定义
        /// </summary>
        /// <param name="con"></param>
        public ClientEntities(System.Data.Common.DbConnection con):base(con, contextOwnsConnection:false)
        {
//详见书196
        }

                //Code First用法
                //var con = new SqlConnection(AppConfig.DataBaseConnectionString());
                //dbContext = new ClientEntities(con);
                //DB First 用法
                dbContext = new ClientEntities();

        /// <summary>
        /// 获取entity模型数据库连接
        /// </summary>
        /// <returns></returns>
        public static string DataBaseConnectionString()
        {
            string DataSource = ConfigurationManager.AppSettings["Server"].ToString();
            string DataBase = ConfigurationManager.AppSettings["DataBase"].ToString();
            string UserId = ConfigurationManager.AppSettings["User"].ToString();
            string PassWord = ConfigurationManager.AppSettings["Password"].ToString();
            return string.Concat("data source=" + DataSource + ";initial catalog=" + DataBase + ";persist security info=True;user id=" + UserId + ";password=" + PassWord + ";MultipleActiveResultSets=True;App=EntityFramework");
        }

加密解密的就自己发挥啦，网上很多很多！！！