Code:public SqlCommand GetCommand(string commandText, CommandType commandType, params SqlParameter[] parameters) { SqlCommand cmd = new SqlCommand(); cmd.Connection = GetConnection(); cmd.CommandText = commandText; cmd.CommandType = commandType; foreach(SqlParameter p in parameters) { cmd.Parameters.Add(p); } return cmd; } public SqlCommand GetCommand(string commandText, params SqlParameter[] parameters) { return GetCommand(commandText, CommandType.StoredProcedure, parameters); }