.net - 为什么DataContext.Connection.ConnectionString 获取不到密码

Question

class Program
{
    private const string Sqlconnstr = "Data Source=.;Initial Catalog = LINQtoSQL;UID = Scarface;PWD = kaka1983513!;";

    static void Main(string[] args)
    {
        var dataContext = new DataContext(Sqlconnstr);
        var books = dataContext.GetTable<Book>();
        var query = from book in books
                    select book;
        var list = query.ToList();  //If i uncomment this line,i can't get the full string without 'PWD = 123456'.
        Console.WriteLine(dataContext.Connection.ConnectionString);

        Console.ReadLine();
    }
}

如何在 query.ToList() 命令后使用 'PWD = 123456' 获取完整字符串。

Answer 1

我不确定为什么您需要重新读取连接信息，但我认为您遇到的问题是 PersistSecurityInfo :

When set to false or no (strongly recommended), security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state. Resetting the connection string resets all connection string values including the password. Recognized values are true, false, yes, and no.

此连接字符串参数的默认值为 false。