title: Passing ConnectionString for Entity constructor must include provider="System.Data.SqlClient" & providerName="System.Data.EntityClient"
body: <p>I need to pass a the connection string to an Entity object constructor (cannot be stored in config).</p>
  
  <p>I have successfully used the EntityConnectionStringBuilder to connect to the database but believe because it does not allow me to add <code>providerName="System.Data.EntityClient"</code> (only the provider property > <code>provider="System.Data.SqlClient</code>") will not let me update the database.</p>
  
  <p>How can this be passed to the constructor along with the connection string from the string builder.</p>
  
  <p>My connection string is basically identical to this </p>
  
  <pre><code>connectionString="metadata=.\AdventureWorks.csdl|.\AdventureWorks.ssdl|.\AdventureWorks.msl;
           provider=System.Data.SqlClient;provider connection string='Data Source=localhost;
           Initial Catalog=AdventureWorks;Integrated Security=True;Connection Timeout=60;
           multipleactiveresultsets=true'" providerName="System.Data.EntityClient"
  </code></pre>