# Query and QuerySingle

Query<T> reads many rows into objects; QuerySingle, QuerySingleOrDefault, QueryFirst and QueryFirstOrDefault read one; ExecuteScalar<T> reads one value. Pick by how many rows you expect.

![Cheat sheet: Query and QuerySingle](https://fsdtrainingmedia.blob.core.windows.net/public/images/2026/11/b19b9ea063c54aebbc5bbbdac806fcc2.webp)

- Category: C#
- Level: Journeyman
- Tags: c-sharp, ExecuteScalar<T>(), Query<T>(), QuerySingleOrDefault<T>(), t-sql
- Updated: November 3, 2026

Source: https://www.ask-codey.com/cheat-sheets/dapper-query-and-querysingle-cheat-sheet