Note that there are some explanatory texts on larger screens.

plurals
  1. POASP.NET MVC4 Simple Membership fails to initialize if using Entity Connection String (works with SQL connection string)
    primarykey
    data
    text
    <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>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload