View Single Post
  #4 (permalink)  
Old July 11th, 2013, 02:29 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts

Hi there,
Guess I shouldn't have deleted my PlanetWroxTemp database so quickly.
The Temp database was only used to demonstrate some concepts. You don't need it for the PlanetWrox site.

The strange thing is my PlanetWrox database points to my C:\BegASPNET\Site\App_Data folder
That's where you added it when you created the MDF file initially (when you followed the exercises). During development, having the database in Ap_Data can be quite handy as you can copy the entire site from one location to another, without external dependencies like a database.

You can move the database to C:\Databases but then you have to update the attachdbfilename attribute in Web.config to point to C:\Databases or you can attached the database to SQL Server and then update your connection strings to point your local server and database name instead of its location (using Initial Catalog). Appendix B has more info.


Imar Spaanjaars
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
The Following User Says Thank You to Imar For This Useful Post:
nudirection (July 11th, 2013)