ExecuteReader, ExecuteNonQuery and ExecuteScalar
What is difference between ExecuteReader, ExecuteNonQuery and 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.
Posted By : Pratik Pachani
Stay Connected
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.
Posted By : Pratik Pachani
Stay Connected
No comments:
Post a Comment