public static DynamicParameters AddOutputParameter(
this DynamicParameters parameters,
string name,
DbType?dbType = null
)
{
return(parameters.AddParameter(name, null, dbType, ParameterDirection.Output));
}
public static DynamicParameters AddInputParameter(
this DynamicParameters parameters,
string name,
object value = null,
DbType?dbType = null
)
{
return(parameters.AddParameter(name, value, dbType, ParameterDirection.Input));
}
public override void AddParameter(string parameterName, object value)
{
_command.Parameters.Add(new SqlParameter(parameterName, value));
_parameters.AddParameter(parameterName, value);
}
public static void AddParameter(this DynamicParameters param, string name, object value)
{
if (value is string)
{
param.AddParameter(name, value.ToString());
}
else if (value is UInt16)
{
param.AddParameter(name, (UInt16)value);
}
else if (value is UInt16?)
{
param.AddParameter(name, (UInt16?)value);
}
else if (value is UInt32)
{
param.AddParameter(name, (UInt32)value);
}
else if (value is UInt32?)
{
param.AddParameter(name, (UInt32?)value);
}
else if (value is UInt64)
{
param.AddParameter(name, (UInt64)value);
}
else if (value is UInt64?)
{
param.AddParameter(name, (UInt64?)value);
}
else if (value is short)
{
param.AddParameter(name, (short)value);
}
else if (value is short?)
{
param.AddParameter(name, (short?)value);
}
else if (value is int)
{
param.AddParameter(name, (int)value);
}
else if (value is int?)
{
param.AddParameter(name, (int?)value);
}
else if (value is long)
{
param.AddParameter(name, (long)value);
}
else if (value is long?)
{
param.AddParameter(name, (long?)value);
}
else if (value is bool)
{
param.AddParameter(name, (bool)value);
}
else if (value is bool?)
{
param.AddParameter(name, (bool?)value);
}
else if (value is DateTime)
{
param.AddParameter(name, (DateTime)value);
}
else if (value is DateTime?)
{
param.AddParameter(name, (DateTime?)value);
}
else if (value is byte[])
{
param.AddParameter(name, (byte[])value);
}
else if (value is byte)
{
param.AddParameter(name, (byte)value);
}
else if (value is byte?)
{
param.AddParameter(name, (byte?)value);
}
else if (value is decimal)
{
param.AddParameter(name, (decimal)value);
}
else if (value is decimal?)
{
param.AddParameter(name, (decimal?)value);
}
else if (value is double)
{
param.AddParameter(name, (double)value);
}
else if (value is double?)
{
param.AddParameter(name, (double?)value);
}
else if (value is Guid)
{
param.AddParameter(name, (Guid)value);
}
else if (value is Guid?)
{
param.AddParameter(name, (Guid?)value);
}
}
