C# for Programmers, Second Edition

20. Database, SQL and ADO.NET

It is a capital mistake to theorize before one has data.

—Arthur Conan Doyle

Now go, write it before them in a table, and note it in a book, that it may be for the time to come for ever and ever.

—Holy Bible, Isaiah 30:8

Get your facts first, and then you can distort them as much as you please.

—Mark Twain

I like two kinds of men: domestic and foreign.

—Mae West

Objectives

In this chapter you will learn:

• The relational database model.

• To write basic database queries in SQL.

• To add data sources to projects.

• To use the IDE’s drag-and-drop capabilities to display database tables in applications.

• To use the classes of namespaces System.Data and System.Data.SqlClient to manipulate databases.

• To ...