What are the different methods available under sqlcommand class to access the data?
237427-Jan-2014
interview
Home / DeveloperSection / Interviews / What are the different methods available under sqlcommand class to access the data?
Home / DeveloperSection / Interviews / What are the different methods available under sqlcommand class to access the data?
Sumit Kesarwani
27-Jan-2014ExecuteReader - 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.