Differents between ExecuteReader, ExecuteNonQuery & ExecuteScalar

ExecuteReader : Use for accessing data. It provides a forward-only, read-only, connected recordset.

ExecuteNonQuery : Use for data manipulation, such as Insert, Update, Delete.

ExecuteScalar : Use for retriving 1 row 1 col. value.,
i.e. Single value.
eg: for retriving aggregate function.
It is faster than other ways of retriving a single value from DB.

Comments

Popular posts from this blog

MVC Request Execution Stages - Life Cycle

Overview of MVC

SOLID Principles with C#

Auto Refresh .aspx page - ASP.NET

Polymorphism in C#

Applying Dynamic Themes to WebPage

ASP.NET MVC: Benefits

How to Edit More than 200 Rows in SQL Server 2008