Two databases in my MVC ASP.NET movies tutorial

Hi there,

I am totally new to MVC and am doing the Movies tutorial on the ASP.NET MVC site.

I have been given two connection strings.. essentially adding another connection string to the one that was already in the webconfig <connectionsStrings> section.

The project uses the Entity Framework to create the database in SQLEXPRESS from the model. However, I end up with two databases - one for the security and one for Movies... further I also end up with the Security database under App_data and the other in the data directory within the SQLEXPRESS direcctories.

By the way I also added in the option of "User Instance=true" to try and force it into the local dirctory

My connection strings as given by the tutorial are:

	<connectionStrings>
		<add name="ApplicationServices"
         connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
         providerName="System.Data.SqlClient" />
		<add name="MovieDBContext"
     connectionString="Server=.\SQLEXPRESS;
     Database=Movies;Trusted_Connection=true"
     providerName="System.Data.SqlClient" />
	</connectionStrings>

Select allOpen in new window

I removed the second connection string all together and it still created a database called MvcMovie.Models.Movie+MovieDBContext in the SQLEXPRESS data directory.

How do I have only one database that sits within the project... what connection string will support that...

It puts the security  e.g Login/user details in another database.....

Simon