You create a DbCommand to execute a query. You need to retrieve a DbDataReader that you can use to access the result set.

Which DbCommand method should you use?

Use the DbCommand.ExecuteDbDataReader method to execute the command text against the connection and return a DbDataReader.

Use the DbCommand.Prepare method to create a prepared (or compiled) version of the command on the data source. This method does not execute a command.