Which SqlCommand property we have to set to StoredProcedure if we are using Stored Procedure name in code?

CommandType property of SqlCommand object is used for setting whether command-type is Text or StoredProcedure.

For ex:-

SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_insert_employee_master_record";
cmd.CommandType = CommandType.StoredProcedure;