/// <summary>
/// Shortcut for adding command parameter.
/// </summary>
/// <param name="target">The command to add a parameter to.</param>
/// <param name="name">The name of the parameter.</param>
/// <param name="value">The value of the parameter.</param>
/// <param name="type">The DbType of the parameter.</param>
/// <param name="direction">The direction of the parameter.</param>
/// <returns>The created IDbDataParameter.</returns>
public static IDbDataParameter AddParameter(this IDbCommand target,
string name, object value, DbType type, ParameterDirection direction = ParameterDirection.Input)
{
var p = target.AddParameterType(name, type);
p.Value = value;
p.Direction = direction;
return(p);
}
/// <summary>
/// Shortcut for adding command a typed return parameter.
/// </summary>
/// <param name="target">The command to add a parameter to.</param>
/// <param name="name">The name of the parameter.</param>
/// <param name="type">The DbType of the parameter.</param>
/// <returns>The created IDbDataParameter.</returns>
public static IDbDataParameter AddReturnParameter(this IDbCommand target,
DbType type, string?name = null)
=> target.AddParameterType(name, type, ParameterDirection.ReturnValue);
