DbCommandExtensions is a class containing extension-methods for System.Data.IDbCommand interface.

DbCommandExtensions

using System.Data;

namespace Helpers
{
    public static class DbCommandExtensions
    {
        public static void AddParameter(this IDbCommand cmd, string parameterName)
        {
            IDbDataParameter parameter = cmd.CreateParameter();
            parameter.ParameterName = parameterName;
            cmd.Parameters.Add(parameter);
        }

        public static void SetParameter(this IDbCommand cmd, string parameterName, object value)
        {
            IDbDataParameter parameter = cmd.CreateParameter();
            parameter.ParameterName = parameterName;
            parameter.Value = value;
            cmd.Parameters.Add(parameter);
        }

        public static void SetParameterValue(this IDbCommand cmd, string parameterName, object value)
        {
            IDbDataParameter parameter = cmd.Parameters[parameterName] as IDbDataParameter;
            if (parameter != null)
                parameter.Value = value;
        }
    }
}