I have created a web site (with help from Professional ASP.NET 4 in C# and VB
) and it works fine on my local machine. When I tried to deploy to the server at my hosting company I ran into problems. It appears that VS defaults to creating the Provider databases in SqlExpress. When I tried to deploy, I got errors saying that SqlExpress wasn't installed on the server. How do I tell VS that it needs to use SQL 2008 in release, but SqlExpress in debug for the Provider databases?