Microsoft Visual Studio 2008 Unleashed

Chapter 18. 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 2008 and SQL Server.

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

• Solution Explorer

• Server Explorer

• Database Diagram Designer

• Table Designer

• Query and View Designer

Collectively, they are referred to as the Visual Database tools. We introduced a few of these tools earlier, in Chapter 5, “Browsers and Explorers.” Now we have ...