Microsoft® Visual Studio® 2012 Unleashed, Second Edition

Chapter 20. Working with Databases

In This Chapter

• Creating Tables and Relationships

• Working with SQL Statements

• Using Database Projects

• Creating Database Objects in Managed Code

• Binding Controls to Data

• Object Relational Mapping

This chapter is all about how you can manage databases and build data-aware applications using Visual Studio and SQL Server.

Six different Visual Studio tools enable you to interact with a database and assist with building applications that leverage data from a database:

• Solution Explorer

• Server Explorer

• SQL Server Object Explorer

• Database Diagram Designer

• Table Designer

• Query and View Designer

Collectively, they are referred to as the SQL Server Data Tools (SSDT). You first came across a few ...