DbCommand Object (ADO.NET)

DbCommand object is used to send a SQL command to the data store. It can be a Data Manipulation Language (DML) command to retrieve, insert, update, or delete data. The DbCommand object can also be a Data Definition Language (DDL) command, which enables you to create tables and modify schema information at the database.

The following sample shows how to create and initialize a DbCommand object.


var ConnStr = ConfigurationManager.ConnectionStrings["myConnectionString"];

var myconnection = new SqlConnection(ConnStr.ConnectionString);

var myCommand = myconnection.CreateCommand();
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.CommandText = "EmpList";

Above code sample creates a DbConnection object that is an instance of SqlConnection. Then it creates a SqlCommand object named myCommand. When the CommandType property is set to StoredProcedure, the CommandText property should be set to the name of the stored procedure to be accessed.

CommandType Enumeration

Connection String in Web.config file

<connectionStrings>

<add name="myConnectionString" connectionString="Data Source=mySQLServer;Initial Catalog=myDatabase;User ID=myUserID;Password=myPassword" providerName="System.Data.SqlClient" />

</connectionStrings>