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:
connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
I removed the second connection string all together and it still created a database called MvcMovie.Models.Movie+Movi
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.....