ASP.NET membership using SQL Server

Question

I am trying to create an MVC 3 app using asp.net membership in a sql server database. I want to be able to use the Entity Framework for development on this app.

I have created by database and used the aspnet_regsql utility to add the membership tables to the database. The part I'm stuck on is how to connect to this database using my application.

I have added an entity model to the project which generated a new connection string in the web.config and I have tried changing the connectionStringName property on all the membership related entries to the new string like so:

<add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="BlogV1Entities" applicationName="/" />

but this is not working as I am getting errors when trying to create a user through the app or ASP.NET Configuration utility

An error occurred while attempting to initialize a System.Data.SqlClient.SqlConnection object. The value that was provided for the connection string may be wrong, or it may contain an invalid syntax. Parameter name: connectionString

Can anyone point me in the right direction to properly get this setup so my app can access the database?

EDIT: In response to first comment this is what the connection string looks like this:

 connectionString="metadata=res://*/BlogV1Model.csdl|res://*/BlogV1Model.ssdl|res://*/BlogV1Model.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=jesse-laptop;initial catalog=BlogV1;integrated security=True;multipleactiveresultsets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

If you look at the content of the connectionstring "BlogV1Entities", does it look like a normal SQL Server connection string or does it have weird properties with *s in them? If so, it's DB-first or model-first EF(probably 4) connection string. SqlClient doesn't use those... You can extract the connection string from your entity designer and add it as a second connection string, using that, as a simple option... — Tetsujin no Oni
– Tetsujin no Oni, Commented Jul 3, 2012 at 18:01

Idrees Khan · Accepted Answer · 2012-07-03 18:08:44Z

4

the entity framework connection string won't work when using asp.net membership. I have dont in my project like this; i-e You need separate connection string for that;

your membership connection string;

<add name="DAConnection" connectionString="Data Source=.\sqlexpress;initial catalog=E:\MYWORK\DIGITALASSETSMVC3\DAMVC3\APP_DATA\DAMVC3.MDF;integrated security=True" providerName="Syste.Data.SqlClient" />

you entity framework connection string;

<add name="DAEntities" connectionString="metadata=res://*/Models.DAModel.csdl|res://*/Models.DAModel.ssdl|res://*/Models.DAModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=.\sqlexpress;initial catalog=E:\MYWORK\DIGITALASSETSMVC3\DAMVC3\APP_DATA\DAMVC3.MDF;integrated security=True;multipleactiveresultsets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

answered Jul 3, 2012 at 18:08

Idrees Khan

7,76218 gold badges65 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jesse Carter Over a year ago

Ok that makes sense. This might be a silly question but is there a way to grab the proper connection string out of SQL Server?

Idrees Khan Over a year ago

yes, in visual studio server explorer add you connection. And that will generate connectionstring for you. u can view it by right click on the connection string and go to properties

Jahan Zinedine · Accepted Answer · 2012-07-03 18:20:01Z

2

It's not a valid connection string which can be used by Membership, it's kind of special connection string just can be used by EF (because of different provideName which Membership expect AFAIK).

Add a clear regular connection string and reference to it instead.

edited Jul 3, 2012 at 18:20

answered Jul 3, 2012 at 18:09

Jahan Zinedine

14.9k5 gold badges49 silver badges74 bronze badges

Collectives™ on Stack Overflow

ASP.NET membership using SQL Server

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related