| ExecuteReader |
|---|
| Use for accessing data. It provides a forward-only, read-only, connected record set. |
| 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. |
No comments:
Post a Comment