mvc3 and entity deployment - Will Entity create tables?

Question

I'm super new to all this, so this may be a silly question.

I'm deploying a mvc3 app. Locally I have two databases, one came built in and contains the users/membership/roles, etc the other is for my dbcontext.

Local connection:

<connectionStrings>
<add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
<add name="MembershipExtContext" connectionString="Data Source=|DataDirectory|invoice.sdf" providerName="System.Data.SqlServerCe.4.0"/>
</connectionStrings>

I need to deploy to (preferably) one database catalog. How do I do this? Do I need two catalogs? Will Entity still create the tables and such?

I was given a connection string for the new database.

I'm very confused. I hope someone can help.

The database on the server is sql2005. I am using entity code first.

here is a similar question, it may help you stackoverflow.com/questions/7526018/asp-net-mvc-3-configuration/… — Rafay
– Rafay, Commented Sep 23, 2011 at 20:07

Craig Stuntz · Accepted Answer · 2011-09-23 18:47:42Z

0

You will need a connectionString for ASP.NET membership, and another for EF. It's fine if both point to the same DB.

Yes, you can use EF's DB initializer to create DB tables if you like, but it cannot create the membership tables. For that, you need to use aspnet_regsql.exe. The built in DB initialization strategies won't support evolving a schema in place, however. So you must either first create EF tables with your model and then run aspnet_regsql.exe before logging in or, perhaps preferably, use something like the forthcoming code-first migrations or the database generation power pack to evolve the DB schema in place.

edited Sep 23, 2011 at 18:47

answered Sep 23, 2011 at 18:41

Craig Stuntz

127k12 gold badges257 silver badges275 bronze badges

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

Collectives™ on Stack Overflow

mvc3 and entity deployment - Will Entity create tables?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related