ef 数据库连接字符串加密

在实际生产环境中，数据库连接字符串需要加密。

先找到ef读取连接字符串的方法：DB.Context.cs

这是默认读取字符串的方法，其对于配置项为：

 <connectionStrings>
    <add name="ConnectionString" connectionString="metadata=res://*/EFYZ.csdl|res://*/EFYZ.ssdl|res://*/EFYZ.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=数据库连接地址;initial catalog=数据库名;persist security info=True;user id=user;Password=password;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>

在这里必须读取解密后发的字符串，所以再写一个方法来获取解密后的字符串EfConstant

using Maticsoft.DBUtility;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Text;

namespace DBUtility
{
   public class EfConstant
    {   /// <summary>
        /// 获取连接字符串
        /// </summary>
        public static string ConnectionString
        {
            get
            {
                string _connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; ;
                string ConStringEncrypt = ConfigurationManager.AppSettings["ConStringEncrypt"];
                if (ConStringEncrypt == "true")
                {
                    _connectionString = DESEncrypt.Decrypt(_connectionString);
                }
                return _connectionString;
            }
        }
    }
}

 

然后替换原来的：

   public Entities()
            : base(EfConstant.ConnectionString)
        {

        }

加密连接字符串的时候要注意，""是双引号，加密时要将其改为" "才可以，不然会报出data source关键字的错误！

 <connectionStrings>
    <add name="ConnectionString" connectionString="16769AC77F58378704A14FAE2725FC1391CA630C924D78993FCC7C72B35CA56804053019BA42DE379ED3775E35DC937C3687E6ED2032C6DF50053082592BDABB78710C4ABEF464C40A852392B08E8A480B881B1A5A9351AA0258BD94780FFF1FDFD2F4619D4F47BBE10D22E8B9B78946E955DC3A5BE58354E1A67DB35A3EB6F790ED11DB64D97D4F10542F3E71E8B59959EF03EE906D0F55D31F9B7EF0213AAE828E5A6D5ADDD6C44DE544E2AA5DF7C07A501EAB708CF2633916F02A76B0104D3D69144B2162DA01B60A4A23C91577582C5EB62FFEB59E66B3F9B97BE6C1C28D417591B13E037A5379A00F980D0160ACF30C8C4BACA630D10447A0CADC1CD453547C09CCB4399429171E19A973D62ABA9B2F5D9ECC3AFF5FC24F8570AEE605C328AD7E11E8D89C02DDCB5A899E791D5F" providerName="System.Data.EntityClient" />
  </connectionStrings>

参考来源：https://www.cnblogs.com/xszjk/articles/EFConfig.html