有没有在C＃中的任何连接字符串解析器？ [英] Is there any connection string parser in C#?

问题描述

我有一个连接字符串，我希望能够窥视出例如数据源。 是否有一个解析器，还是我要搜索的字符串？

I have a connection string and I want to be able to peek out for example "Data Source". Is there a parser, or do I have to search the string?

推荐答案

是的，还有的<一个href="http://msdn.microsoft.com/en-us/library/system.data.common.dbconnectionstringbuilder.aspx"><$c$c>System.Data.Common.DbConnectionStringBuilder类。

在DbConnectionStringBuilder类   提供基类从中   强类型的连接字符串   建设者（SqlConnectionStringBuilder，   OleDbConnectionStringBuilder等   上）获得。连接字符串   建设者让开发者   编程创建语法   正确的连接字符串和解析   并重建现有连接   字符串。

The DbConnectionStringBuilder class provides the base class from which the strongly typed connection string builders (SqlConnectionStringBuilder, OleDbConnectionStringBuilder, and so on) derive. The connection string builders let developers programmatically create syntactically correct connection strings, and parse and rebuild existing connection strings.

感兴趣的子类是：

System.Data.EntityClient.EntityConnectionStringBuilder
System.Data.Odbc.OdbcConnectionStringBuilder
System.Data.OleDb.OleDbConnectionStringBuilder
System.Data.OracleClient.OracleConnectionStringBuilder
System.Data.SqlClient.SqlConnectionStringBuilder

---

例如，从SQL服务器的连接字符串偷看的数据源，你可以这样做：

---

For example, to "peek out the Data Source" from a SQL-server connection string, you can do:

var builder = new SqlConnectionStringBuilder(connectionString);
var dataSource = builder.DataSource;

这篇关于有没有在C＃中的任何连接字符串解析器？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！