c# - 用分号拆分字符串，同时考虑转义字符

Question

真正简单的问题:

我想将连接字符串拆分为其关键字/值对，例如以下连接字符串:

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=vm-jp-dev2;Data Source=scsql\sql2005;Auto Translate=False

会变成:

Provider=SQLOLEDB.1
Integrated Security=SSPI
Persist Security Info=False
Initial Catalog=vm-jp-dev2
Data Source=scsql\sql2005
Auto Translate=False

问题是 MSDN documentation指出如果值用单引号或双引号字符括起来，则允许连接字符串值包含分号(因此，如果我理解以下内容将是有效的):

Provider="Some;Provider";Initial Catalog='Some;Catalog';...

拆分此字符串的最佳方法是什么(在 C# 中)？

Answer 1

有一个 DBConnectionStringBuilder 类可以做你想做的事......

        System.Data.Common.DbConnectionStringBuilder builder = new System.Data.Common.DbConnectionStringBuilder();

        builder.ConnectionString = "Provider=\"Some;Provider\";Initial Catalog='Some;Catalog';";

        foreach (string key in builder.Keys)
        {
            Response.Write(String.Format("{0}: {1}<br>", key , builder[key]));
        }