214Microsoft Visual Studio 2010: A Beginner’s Guide
used in multiple later chapters that show you how to build user interfaces. Pay attention to how the UI code holds on to IDs and then uses them when calling code that interacts with the database. You’ll see many different examples, but most of the examples that you see and then use in your own programs will be variations of what you’ve learned here.
Summary
This chapter showed you how to work with the VS database tools. You can create tables, relationships, and stored procedures. The section “Querying Object Collections with LINQ” helped you understand basic LINQ queries. You can now use LINQ to SQL, setting up a designer with classes and methods. Additionally, you can create, read, update, and delete data with LINQ to SQL.
This chapter used Console applications to show you how to work with data. This was to help you concentrate on data access exclusively, minimizing any other distractions. However, real applications require graphical user interfaces (GUIs). Remaining chapters of this book will show you how to create GUI applications that consume data, giving you many more examples of how LINQ to SQL works in an application. The next chapter gets you started in GUI development with WPF.
