C#

public static DbParameter Parameter<T>(string parameterName, DbType parameterType, T value, int size)
{
  DbParameter param = Parameter(parameterName, parameterType, value, ParameterDirection.Input);
  param.Size = size;
  return param;
}

public static DbParameter Parameter<T>(string parameterName, DbType parameterType, T value)
{
  return Parameter(parameterName, parameterType, value, ParameterDirection.Input);
}

public static DbParameter Parameter<T>(string parameterName, DbType parameterType, T value, ParameterDirection direction, int size)
{
  DbParameter param = Parameter(parameterName, parameterType, value, direction);
  param.Size = size;
  return param;
}

public static DbParameter Parameter<T>(string parameterName, DbType parameterType, T value, ParameterDirection direction)
{
  DbParameter param = new DbParameter();
  param.Direction = direction;
  param.Name = parameterName;
  param.DbType = parameterType;
  param.Value = value;
  return param;
}

cmd.Parameters.Add(Parameter("@ID", DbType.Int, 100));

<br />
int value1 = 10;<br />
cmd.Parameters.Add(new SqlParameter("@param1", value1));<br />

Brady Kelly wrote:

Or am I missing something?

Zilo(svk) wrote:

Is there any simple way how to change this default behavior