.NET Blog

Free. Cross-platform. Open source. A developer platform for building all your apps.

ASP.NET providers and SQL Azure

We have two sets of ASP.NET providers which currently exist; the ASP.NET SQL providers, and the ASP.NET Universal Providers. In VS 2010 the SQL providers were in only providers used for our project templates. In VS 2012 we have switched to using the Universal Providers. One of the drawbacks of the SQL providers is that it leverages DB objects ...

Database settings in the VS Publish dialog

In Visual Studio 2010 we introduced a database publishing experience in the Package/Publish SQL (PP/SQL) properties page. This support relies on generating create scripts from the source database and then executing those scripts when you publish your web application. For more details regarding this feature take a look at Package/Publish SQL ...

Visual Studio 2010 support with SQL Server

We’ve been getting a few questions by our users about Visual Studio 2010’s support for SQL Server versions.  So I thought it would be good to address them here (when one person asks a question, there are probably others thinking the same question.) Visual Studio 2010 only supports SQL Server 2005+ Visual Studio 2010’s design time ...

Dev10 Beta1, Deploy Web application with SQL Express mdf file to host’s SQL server

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 ...