Tags » Database Project

Visual Studio 2013 Database Project: Working the Project LocalDbs

Visual Studio 2013 Database Project: Working the Project LocalDbs

Overview

Visual Studio (VS) has evolved much to what it is capable of today for database development and deployment.  288 more words

Database

Visual Studio 2013 Database Project: Create a Stored Procedure Item Template

Visual Studio 2013 Database Project-Create a Stored Procedure Item Template

Overview

Using Visual Studio for database development requires that database objects like stored procedures be created, amongst other items such as tables, view, triggers, etc.  2,533 more words

Database

Database Project

For this project, I created a relational database in MySQL and then made a searchable website for it. The database I chose to make was the Top Country Songs of 2013.

Database Website
Database Tables

Best Work

Transposing Entity Framework EDMX to Code First

Not so long ago we’ve been turning our Entity Framework usage from the “database project + edmx” approach to the “Code First” way. Why did we do that? 412 more words

Technical Interest

Database Deployment. Hacking the VS database project. Part 2.

In the last article we looked at how, with the aid of pre-build  tasks, we could combine hand-written update scripts with the Visual Studio database project. 1,196 more words

Database Deployment. Hacking the VS database project. Part 1.

When upgrading an application, it’s fairly easy to deploy your changes; delete all the existing dlls and replace them with a new set. The problem with databases is that they are often infested with pesky data. 1,425 more words

Using Database Project to create Deployment Scripts

Implementing enhancements to your system does not only involve updating your application, but most of the time, it also involves updating the schema of your database. 1,505 more words

SQL Server