EXECUTESCALAR() - It is used to return SINGLE value from the database.
EXECUTENONQUERY() – It returns a RESULTSET from databse and it has multiple values. It can be used for insert, update and delete.
EXECUTEREADER() - It only retrieves data from database. No update, insert. It is readonly.
Tags:
ADO.NET & EF