VS. NET (C #) Database Interface: Command object introduction, vs.net

VS. NET (C #) Database Interface: Command object introduction, vs.net

The Connection object connects the external data source and does not provide any operations on the external data source.

The Command object encapsulates all operations on external data sources (including SQL statements and stored procedures such as SELECT, INSERT, UPDATE, or DELETE) and returns appropriate results after execution.

For different data sources, ADO. NET provides different Command objects, as follows:

● SqlCommand

● OleDbCommand

● OdbcCommand