Sams Teach Yourself ADO.NET in 24 Hours

Crash Course on Database Schema

In a database, such as Microsoft SQL Server, data is stored and organized in tables. Tables consist of a set of columns and a set of rows. The columns (also referred to as “fields”) define what information you are storing about your object (such as name, description, color, and so on). The columns define how your data will look. This is referred to as the database schema. The rows (also referred to as “records”) are your data—each row represents a group of columns of information.

A primary key is a column in your table that guarantees row-level accessibility. This sounds more complicated than it really is. Think of the data in a table organized like a spreadsheet. To access a particular row, the data provider needs ...