- 21.1 Introduction
- 21.2 Relational Databases
- 21.3 Relational Database Overview: Books Database
- 21.4 SQL
- 21.5 LINQ to SQL
- 21.6 LINQ to SQL: Extracting Information from a Database
- 21.7 More Complex LINQ Queries and Data Binding
- 21.8 Retrieving Data from Multiple Tables with LINQ
- 21.9 Creating a Master/Detail View Application
- 21.10 Programming with LINQ to SQL: Address-Book Case Study
- 21.11 Wrap-Up
- 21.12 Tools and Web Resources
This chapter introduced relational databases, SQL, LINQ to SQL and the IDE’s visual programming tools for working with databases. You examined the contents of a simple Books database and learned about the relationships among the tables in the database. You then learned basic SQL statements to retrieve data from, add new data to, delete data from and update data in a database.
We discussed the LINQ to SQL classes generated by the IDE, such as the DataContext that controls interactions with the database. We also explained that LINQ to SQL transforms the LINQ queries you write into SQL, which is then sent to the database.
Next, the chapter focused on using the IDE’s tools and wizards to access and manipulate data sources like databases in GUI applications. You learned how to generate LINQ to SQL classes and how to use the IDE’s drag-and-drop capabilities to display database tables in applications. We discussed the IDE’s wizards that help you create fully functional applications requiring just a few lines of code.
In the next chapter, we demonstrate how to build web applications using Microsoft’s ASP.NET technology. We also introduce the concept of a three-tier application, which is divided into three pieces that can reside on the same computer or be distributed among separate computers across a network such as the Internet. One of these tiers—the information tier—typically stores data in an DBMS like SQL Server.