You create a SqlCommand object “com” in order to execute a SQL Query on a database table. Which code snippet should you use in order to select all records from the table “Customers”?

69.

You create a SqlCommand object “com” in order to execute a SQL Query on a database table.
Which code snippet should you use in order to select all records from the table “Customers”?

com.CommandText = “SELECT * FROM Customers”;
com.CommandType = CommandType.StoredProcedure;

com.CommandText = “SELECT * FROM Customers”;
com.CommandType = CommandType.TableDirect;

com.CommandText = “Customers”;
com.CommandType = CommandType.Text;

com.CommandText = “Customers”;
com.CommandType = CommandType.TableDirect;

View Description

When the CommandType property is set to TableDirect, the CommandText property should be set to the name of the table to be accessed