For many web applications developed using Visual Studio, developers uses SQL express with mdf database file under app_data folder. If deploying data host requires SQL server, developers have to find ways to deploy the schema and data from mdf file to the host SQL server. Dev10 Beta1 provides an easy solution to publish the mdf file to the SQL Server host along with other application files. Here?s a walkthrough. 1. Create a new web application, create a SQL Server Database under app_data folder. Add some tables to the database, drag a table to the default.aspx designer. Ctrl-F5 to test it making sure it works. 2. Check the web.config file, note it has a connection string such as following: < connectionStrings > <...(read more)
Go to the complete details ...