.NET Blog

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

Database - .NET Blog

ASP.NET providers and SQL Azure

June 14, 2012 Jun 14, 2012 06/14/12
Web Development Tools Microsoft
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

June 14, 2012 Jun 14, 2012 06/14/12
Web Development Tools Microsoft
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

May 3, 2010 May 3, 2010 05/3/10
Web Development Tools Microsoft
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 Beta2, Import from web.config file and other changes for DB deployment UI

October 23, 2009 Oct 23, 2009 10/23/09
Web Development Tools Microsoft
Dev10 Beta2 DB Deployment property page has some changes from Beta1.  Please provide your valuable feedback for us to make it better for you.  Thanks. (image) 1. Tab page name changed from “Deploy/SQL” To “Deploy SQL” 2. Customer can use “Import from Web.config” button to import all the connection strings defined in ...

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

September 28, 2009 Sep 28, 2009 09/28/09
Web Development Tools Microsoft
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 ...

VS2010 Beta1 "Delete existing objects before creating" flag for DB Deployment

July 2, 2009 Jul 2, 2009 07/2/09
Web Development Tools Microsoft
  Here is an example of end to end scenario of the last blog VS2010 Beta1 Web Application Project Database package and SMO options. Here, we’re going to package a web application and its database with “Delete existing objects before creating” flag, so that we can test the deploy multiple times without the need to drop the database ...

VS2010 Beta1 Web Application Project Database package and SMO options

June 29, 2009 Jun 29, 2009 06/29/09
Web Development Tools Microsoft
In Visual Studio 2010 Beta1 release, SQL server database schema and data can be packaged for deployment along with the website.  It utilizes Msdeploy SQL Database provider functionality in IIS team’s msdeploy release.  In Visual studio 2010 Beta1, user can set the database package options in web application project’s Deploy-SQL...