# ADO.NET Objects

Use SqlConnection to connect, SqlCommand to run SQL, and SqlDataReader to read rows, choosing ExecuteReader, ExecuteScalar or ExecuteNonQuery for each kind of statement.

![Cheat sheet: ADO.NET Objects](https://fsdtrainingmedia.blob.core.windows.net/public/images/2026/11/ef7b5d51a9074454a4548e9dfe342f44.webp)

- Category: C#
- Level: Journeyman
- Tags: c-sharp, SqlCommand, SqlConnection, SqlDataReader, t-sql
- Updated: November 3, 2026

Source: https://www.ask-codey.com/cheat-sheets/querying-a-database-with-ado-net-ado-net-objects-cheat-sheet