在App.config中加密密码 [英] Encrypt password in App.config

问题描述

我想加密连接字符串中的密码。当我连接到DB时，连接字符串被公开存储在App.config中，我需要找到一种只保密码加密的方法。

I want to encrypt the password in connection string. When I make a connection to DB the connection string is openly stored in App.config and I need to find a way to keep only password encrypted.

推荐答案

让我们说这是你的连接字符串：

Lets say this is your connection string:

<connectionStrings>
    <add name="cs" connectionString="Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=XXSDFASFDKSFJDKLJFDWERIODFSDFHSDJHKJNFJKSD;"/>
</connectionStrings>

然后你可以这样做：

string myCs = System.Configuration.ConfigurationManager.ConnectionStrings["cs"].ConnectionString;

System.Data.SqlClient.SqlConnectionStringBuilder csb = new System.Data.SqlClient.SqlConnectionStringBuilder(myCs);
csb.Password = EncDecHelper.Decrypt(csb.Password);
myCs = csb.ToString();

您可以使用 EncDecHelper.Decrypt 来自此处的示例：加密和解密字符串

You can write EncDecHelper.Decrypt by using samples from here: Encrypt and decrypt a string

这篇关于在App.config中加密密码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！