Visual Studio / .NET

W12 Automated Build, Test, & Deploy with TFS, ASP.NET, and SQL Server

06/03/2015

1:30pm - 2:45pm

Level: Intermediate to Advanced

Benjamin Day

Consultant & Trainer

Benjamin Day Consulting, Inc.

Automatically building your ASP.NET code is easy. Create a TFS build and go. But what about the database code? How does that get built? If you've got code that that calls the database, how do you test that from an automated build? What about testing those stored procedures and functions? And then there are deployment hassles. How do you deploy the ASP.NET application and the database code in an automated fashion from a build? It would be nice to just run a build and have everything deployed and configured.

In this session, we'll start by showing you how to use SQL Server Data Tools Projects (SSDT) to manage your database changes and unit test your database code. Next we'll put that SQL Server code into TFS version control using Git and TFVC. Then we'll create a build that will compile and test an ASP.NET application. And finally, we'll show you how to deploy these changes to either IIS or Windows Azure with a TFS Build using either PowerShell or Team Foundation Server Lab Management.

You will learn:

  • How to manage SQL Server schemas and lookup data under source control using SSDT
  • The importance of versioning database code with compiled (C#) code
  • The basics of TFS Builds (Controllers, Agents, Build Definitions) with Git & TFVC
  • How to build customization using Pow