SqlConnectionExtensions.cs

public static class SqlConnectionExtensions {
	public static SqlCommand CreateCommand(this SqlConnection connection, string cmdText, CommandType cmdType = CommandType.Text, params SqlParameter[] parameters) {
		var cmd = connection.CreateCommand();
		cmd.CommandText = cmdText;
		cmd.CommandType = cmdType;
		if (parameters != null)
			foreach (var parameter in parameters)
				cmd.Parameters.Add(parameter);
		return cmd;
	}

	public static SqlCommand CreateCommand(this SqlConnection connection, string cmdText, CommandType cmdType = CommandType.Text, Dictionary<string, object> parameters = null) {
		var cmd = connection.CreateCommand();
		cmd.CommandText = cmdText;
		cmd.CommandType = cmdType;
		if (parameters != null)
			foreach (var parameter in parameters)
				cmd.Parameters.AddWithValue(parameter.Key, parameter.Value);
		return cmd;
	}
}