Filter
Top Products
214 Microsoft 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.