SimpleMembership connectionStringName API connection error

I am trying to use SimpleMembership in my MVC 3 application. However, I am getting the following error:

The System.ArgumentException fix was unhandled by the user code. Could not find requested .Net Framework Provider data. It cannot be installed.

I am using EF and the structure obviously exists since my application works fine without the SimpleMembership API

Here is the setting in the Web configuration file:

<connectionStrings>
  <add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" />
  <add name="SeniorProjectModelContainer" connectionString="metadata=res://*/Models.SeniorProjectModel.csdl|res://*/Models.SeniorProjectModel.ssdl|res://*/Models.SeniorProjectModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=GOGOTOPPY;Initial Catalog=SPMT;Integrated Security=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
</connectionStrings>

And how it looks in the Membership file in the App_Start folder:

WebSecurity.InitializeDatabaseConnection(connectionStringName: "SeniorProjectModelContainer", userTableName: "Users", userIdColumn: "UserId", userNameColumn: "UserName", autoCreateTables: true);

Any help would be greatly appreciated!

Update:

The quick work was to extract some of the metadata from the connection string and change the provider name to SqlClient so that it looked something like this:

<connectionStrings>
  <add name="Membership" connectionString="Data Source=serverName;Database=datebaseName;User ID=idName;Password=password;Trusted_Connection=False;Encrypt=True;" providerName="System.Data.SqlClient" />
</connectionStrings>

, ?

+3
1
0

All Articles