数据库连接字符串解析的正则表达式

<span>   1:</span> <span>/// <summary></span>

<span>   2:</span> <span>/// 修复连接字符串，将数据库文件相对路径的转换为绝对路径。</span>

<span>   3:</span> <span>/// </summary></span>

<span>   4:</span> <span>/// <param name="connectionString">连接字符串的值。</param></span>

<span>   5:</span> <span>/// <returns>返回被修整过的连接字符串，如果无需修整则返回参数原值。</returns></span>

<span>   6:</span> <span>private</span> <span>static</span> <span>string</span> FixConnectionString(<span>string</span> connectionString)

<span>   7:</span> {

<span>   8:</span>     <span>const</span> <span>string</span> DATASOURCE_PATTERN = <span>@"(?<=Data\s+Source\s*=\s*['"</span><span>"]*\s*)\w+[^;'"</span><span>"]+(?=\b)"</span>;

<span>   9:</span>  

<span>  10:</span>     <span>if</span>(<span>string</span>.IsNullOrEmpty(connectionString))

<span>  11:</span>         <span>return</span> connectionString;

<span>  12:</span>  

<span>  13:</span>     Match match = Regex.Match(connectionString, DATASOURCE_PATTERN, RegexOptions.IgnoreCase | RegexOptions.Singleline);

<span>  14:</span>     <span>if</span>(!match.Success)

<span>  15:</span>         <span>return</span> connectionString;

<span>  16:</span>  

<span>  17:</span>     <span>if</span>(Path.IsPathRooted(match.Value))

<span>  18:</span>         <span>return</span> connectionString;

<span>  19:</span>  

<span>  20:</span>     <span>string</span> directoryName = Path.GetDirectoryName(Assembly.GetExecutingAssembly().GetName().CodeBase);

<span>  21:</span>     <span>string</span> dataSource = Path.Combine(directoryName, match.Value);

<span>  22:</span>  

<span>  23:</span>     <span>return</span> Regex.Replace(connectionString, DATASOURCE_PATTERN, dataSource, RegexOptions.IgnoreCase | RegexOptions.Singleline);

<span>  24:</span> }