title: is it possible to get the connection string to ADO from a connection string for entity framework?
body: <p>I have a connection string in my app config that is:</p>
  
  <pre><code>&lt;connectionStrings&gt;
      &lt;add name="MyEFConnection" connectionString="metadata=res://*/Model.AAA.csdl|res://*/Model.AAA.ssdl|res://*/Model.AAA.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;data source=MyComputer\SQLEXPRESS;initial catalog=ABCD;integrated security=True;multipleactiveresultsets=True;App=EntityFramework&amp;quot;" providerName="System.Data.EntityClient" /&gt;
    &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>But in a particular case I want to use ADO.NET to execute a T-SQL, so I using this code:</p>
  
  <pre><code>SqlConnection myConnection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["MyEFConnection"].ConnectionString);
  </code></pre>
  
  <p>But I get an exception that says that the Metada word is not valid. There is any way to use the information in the connetion string for EF or I need to add a new string connection in my app config to the ADO.NET connection?</p>
  
  <p>Thanks.</p>