title: ASP.NET MVC4 Simple Membership fails to initialize if using Entity Connection String (works with SQL connection string)
body: <p>I am developing ASP.NET MVC4 application with Entity Framework 5, and I am using Model First mode.</p>
  
  <p>However Simple Membership will throw the following error if I am using the connection string generated by the designer:</p>
  
  <pre><code>    ......
    InnerException: System.InvalidOperationException
     HResult=-2146233079
     Message=The ASP.NET Simple Membership database could not be initialized. For more information, please see http://go.microsoft.com/fwlink/?LinkId=256588
     Source=STD
     StackTrace:
          at SistemTempahanDewan.Filters.InitializeSimpleMembershipAttribute.SimpleMembershipInitializer..ctor() in c:\Users\Orang\Documents\Visual Studio 2012\Projects\STD\STD\Filters\InitializeSimpleMembershipAttribute.cs:line 45
     InnerException: System.ArgumentException
          HResult=-2147024809
          Message=Unable to find the requested .Net Framework Data Provider.  It may not be installed.
          Source=System.Data
          StackTrace:
               at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)
               at WebMatrix.Data.DbProviderFactoryWrapper.CreateConnection(String connectionString)
      ....
  </code></pre>
  
  <p>Connection string generated by the designer (will not work):</p>
  
  <pre><code>&lt;add name="STD" connectionString="metadata=res://*/Models.STD.csdl|res://*/Models.STD.ssdl|res://*/Models.STD.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;data source=.\SQLEXPRESS;initial catalog=STD;integrated security=True;multipleactiveresultsets=True;App=EntityFramework&amp;quot;" providerName="System.Data.EntityClient" /&gt;
  </code></pre>
  
  <p>Connection string I add manually (will work):</p>
  
  <pre><code>&lt;add name="STD" providerName="System.Data.SqlClient" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=STD;Integrated Security=True;MultipleActiveResultSets=True" /&gt;
  </code></pre>