Extract properties from a connection string using Regex

Question

In C# I am trying to get the Data Source and initial catalog properties from a connection string.

So if I have

metadata=res://*/model.csdl|res://*/model.ssdl|res://*/model.msl;provider=System.Data.SqlClient;provider connection string="data source=myDESKTOP;initial catalog=dbName;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"

How can I extract just the values myDESKTOP and dbName regardless of case on the left hand of the expression?

Why regex when you can do it this way stackoverflow.com/a/10550705/2093880 — usefulBee
– usefulBee, Commented Nov 15, 2017 at 15:37

Steve · Accepted Answer · 2017-11-15 15:42:45Z

2

You could dissect your connection string for Entity Framework and extract the internal basic connection string. At that point the SqlConnectionStringBuilder could give you the individual parts that compose the connection string

string test = "metadata=res://*/model.csdl|res://*/model.ssdl|res://*/model.msl;provider=System.Data.SqlClient;provider connection string=\"data source = myDESKTOP; initial catalog = dbName; integrated security = True; MultipleActiveResultSets = True; App = EntityFramework";

string con = string.Join("=", 
                    string.Join(";", test.Split(';').Skip(2))
                          .Split('=').Skip(1)).Trim('"');

SqlConnectionStringBuilder sb = new SqlConnectionStringBuilder(con);
Console.WriteLine(sb.DataSource);
Console.WriteLine(sb.InitialCatalog);

answered Nov 15, 2017 at 15:42

Steve

217k22 gold badges242 silver badges296 bronze badges

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

Collectives™ on Stack Overflow

Extract properties from a connection string using Regex

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