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.

Updated

Cheat sheet: Query and QuerySingle
Category
C#
Level
Journeyman
Tags
c-sharp, ExecuteScalar<T>(), Query<T>(), QuerySingleOrDefault<T>(), t-sql