title: Extract connection string from an Entity Connection String
body: <p>When creating and ADO.NET Entity Connection String you get something like</p>
  
  <pre><code>&lt;add name="MREntities" connectionString="metadata=res://*/App_Code.MembershipAndRoll.MembershipAndRollEntities.csdl|res://*/App_Code.MembershipAndRoll.MembershipAndRollEntities.ssdl|res://*/App_Code.MembershipAndRoll.MembershipAndRollEntities.msl;provider=MySql.Data.MySqlClient;provider connection string=&amp;quot;server=192.168.0.26;User Id=digitaliv;password=*******;Persist Security Info=True;database=digitaliv&amp;quot;" providerName="System.Data.EntityClient" /&gt;
  </code></pre>
  
  <p>My question is how do you grab the true inner connection string from that to call make a manual sql connection to call stored procedures, custom sql statements etc.? Specifically I need this part extracted from it</p>
  
  <pre><code>server=192.168.0.26;User Id=digitaliv;password=*******;Persist Security Info=True;database=digitaliv
  </code></pre>