/// <summary>
/// Converts to a <see cref="SqlParameter"/>.
/// </summary>
/// <param name="dateTimeOutputParameter">The <see cref="DateTime"/> Output parameter.</param>
/// <returns>SqlParameter.</returns>
public static SqlParameter ToSqlParameter(
this OutputParameterDefinition <DateTime> dateTimeOutputParameter)
{
dateTimeOutputParameter.MustForArg(nameof(dateTimeOutputParameter)).NotBeNull();
var name = dateTimeOutputParameter.Name;
name = name.StartsWith("@", StringComparison.Ordinal) ? name : "@" + name;
var result = SqlParameterExtensions.CreateOutputDateTimeSqlParameter(name);
return(result);
}
/// <summary>
/// Converts to a <see cref="SqlParameter"/>.
/// </summary>
/// <param name="decimalOutputParameter">The decimal Output parameter.</param>
/// <returns>SqlParameter.</returns>
public static SqlParameter ToSqlParameter(
this OutputParameterDefinition <decimal> decimalOutputParameter)
{
decimalOutputParameter.MustForArg(nameof(decimalOutputParameter)).NotBeNull();
var dataType = (DecimalSqlDataTypeRepresentation)decimalOutputParameter.SqlDataType;
var name = decimalOutputParameter.Name;
name = name.StartsWith("@", StringComparison.Ordinal) ? name : "@" + name;
var result = SqlParameterExtensions.CreateOutputDecimalSqlParameter(name, dataType.Precision, dataType.Scale);
return(result);
}
/// <summary>
/// Converts to a <see cref="SqlParameter"/>.
/// </summary>
/// <param name="binaryOutputParameter">The decimal Output parameter.</param>
/// <returns>SqlParameter.</returns>
public static SqlParameter ToSqlParameter(
this OutputParameterDefinition <byte[]> binaryOutputParameter)
{
binaryOutputParameter.MustForArg(nameof(binaryOutputParameter)).NotBeNull();
var dataType = (BinarySqlDataTypeRepresentation)binaryOutputParameter.SqlDataType;
var name = binaryOutputParameter.Name;
name = name.StartsWith("@", StringComparison.Ordinal) ? name : "@" + name;
var result = SqlParameterExtensions.CreateOutputByteArraySqlParameter(name, size: dataType.SupportedLength);
return(result);
}
public async Task <List <T> > ExecuteSPAsync <T>(object obj)
{
SqlParameterExtensions sqlParameterExtensions = new SqlParameterExtensions();
List <SqlParameter> sqlParameters = obj != null?sqlParameterExtensions.ToSqlParamsList(obj) : (List <SqlParameter>)obj;
try
{
List <T> result = await _unitOfWork.ExecuteSPAsync <T>(sqlParameterExtensions.GetStoredProcedureName(obj), sqlParameters);
sqlParameterExtensions.ToObject(obj, sqlParameters);
return(result);
}
catch (Exception)
{
throw;
}
}
public void ShouldReturnNullWhenCloneIsCalledWithNullParameter()
{
Assert.That(SqlParameterExtensions.Clone(null), Is.EqualTo(null));
}
