Parsing a Connection String

Question

Is there a standard library or code snippet to get a value with a connection string like this?

string connstr = "DataServiceUrl=http://localhost/foo;" + 
        "RemoteServerConnection={server=http://localhost/foo2;interface=0.0.0.0;};" + 
        "publisherport=1234;StatisticsURL=http://localhost/foo3";

The whole inner connection property is kind of throwing this in a loop. I'd like to get specific values based on a key.

Here was the answer posted by John I used:

System.Data.Odbc.OdbcConnectionStringBuilder builder = new System.Data.Odbc.OdbcConnectionStringBuilder(); 
builder.ConnectionString = this.ConnectionString;
MessageBox.Show(builder["RemoteServerConnection"]);

An answer that short would bring downvotes. I don't have time for a longer answer. — John Saunders
– John Saunders, Commented Dec 15, 2011 at 18:20
Here's the code to post and I'll give you credit for the answer System.Data.Odbc.OdbcConnectionStringBuilder builder = new System.Data.Odbc.OdbcConnectionStringBuilder(); builder.ConnectionString = this.ConnectionString; MessageBox.Show(builder["RemoteServerConnection"]); — dave2118
– dave2118, Commented Dec 15, 2011 at 18:25

Olivier Jacot-Descombes · Accepted Answer · 2014-02-17 17:08:42Z

5

Replacing "{" and "}" by (") does the trick:

string conn = "DataServiceUrl=http://localhost/foo;" +
    "RemoteServerConnection={server=http://localhost/foo2;interface=0.0.0.0;};" +
    "publisherport=1234;StatisticsURL=http://localhost/foo3";

var builder = new System.Data.Common.DbConnectionStringBuilder();
builder.ConnectionString = conn.Replace("{", "\"").Replace("}", "\"");
var keys = builder.Keys;
var values = builder.Values;
string remoteServerConnection = (string)builder["RemoteServerConnection"];

edited Feb 17, 2014 at 17:08

answered Dec 15, 2011 at 18:27

Olivier Jacot-Descombes

114k14 gold badges149 silver badges202 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Parsing a Connection String

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related