IMAT1604: Visual Web Development

SQL Server - LocalDb

Visual Studio 2012 has built in a new version of SQL Server called LocalDb. This is a local file based version that is normally placed in an APP_Data folder in a Visual Studio Project or Web Site.

Database Definition

The Database was created by Adding an ASP.NET Folder called APP_Data, then right clicking on that folder and adding SQL Server Database. A new Table can then be added to the empty database.

A new Stored Procedure can be added, called DeleteWineById which has one SQL parameter called WinesId. See examples in the Software Tools pages:-

LocalDb Tables
LocalDb Fields
LocalDb Scripts
Db Relationships