Showing posts with label ExecuteNonQuery and ExecuteScalar.. Show all posts
Showing posts with label ExecuteNonQuery and ExecuteScalar.. Show all posts

10 June 2010

What is difference between 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 retrieving 1 row 1 col. value., i.e. Single value. eg: for retrieving aggregate function. It is faster than other ways of retrieving a single value from Database.

Consistency level in Azure cosmos db

 Consistency level in Azure cosmos db Azure Cosmos DB offers five well-defined consistency levels to provide developers with the flexibility...