What is ExecuteScalar?

Updated Apr 28, 2026

Short answer

Executes query and returns single value.

Deep explanation

Used for aggregate queries like COUNT, MAX, etc.

Real-world example

Getting total users count.

Common mistakes

Using for multiple rows.

Follow-up questions

When to use ExecuteScalar?
What type does it return?

More ADO.NET interview questions