What are the different methods available under sqlcommand class to access the data?

Question

Sumit Kesarwani · Answer

ExecuteReader - Used where one or more records are returned - SELECT Query. ExecuteNonQuery - Used where it affects a state of the table and no data is being queried - INSERT, UPDATE, DELETE, CREATE and SET queries. ExecuteScalar - Used where it returns a single record.

interview

What are the different methods available under sqlcommand class to access the data?

Can you answer this question?

1 Answers