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

Page Life Cycle in ASP.NET

MVC Request Execution Stages - Life Cycle

Auto Refresh .aspx page - ASP.NET

Parsing the comma separated values into a temporary table

Polymorphism in C#

Introduction to ASP.Net MVC

Differences between a Structure and Class

ASP.NET MVC: Benefits

SOLID Principles with C#