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 ...

Get Microsoft® Visual Studio® 2012 Unleashed, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial