/// <summary>
/// Update the properties of <see cref="MdsNonIdentityCompleteTable"/> instance.
/// </summary>
/// <param name="table">The instance to be updated.</param>
public static void UpdateMdsNonIdentityCompleteTableProperties(MdsNonIdentityCompleteTable table)
{
table.ColumnBigInt = long.MaxValue;
table.ColumnBlob = Encoding.UTF32.GetBytes(Guid.NewGuid().ToString());
table.ColumnBoolean = "true";
table.ColumnChar = char.Parse("C").ToString();
table.ColumnDate = DateTime.SpecifyKind(DateTime.UtcNow, DateTimeKind.Unspecified).Date.ToString(DATE_FORMAT);
table.ColumnDateTime = DateTime.SpecifyKind(DateTime.UtcNow, DateTimeKind.Unspecified).ToString(DATE_FORMAT);
table.ColumnDecimal = Randomizer.Next(1000000);
table.ColumnDouble = Convert.ToDouble(Randomizer.Next(1000000));
table.ColumnInt = Randomizer.Next(1000000);
table.ColumnInteger = Convert.ToInt64(Randomizer.Next(1000000));
table.ColumnNumeric = Randomizer.Next(1000000);
table.ColumnReal = Convert.ToSingle(Randomizer.Next(1000000));
table.ColumnString = $"{table.ColumnString} - Updated with {Guid.NewGuid().ToString()}";
table.ColumnText = $"{table.ColumnText} - Updated with {Guid.NewGuid().ToString()}";
table.ColumnTime = DateTime.SpecifyKind(DateTime.UtcNow, DateTimeKind.Unspecified).ToString(DATE_FORMAT);
table.ColumnVarChar = $"{table.ColumnVarChar} - Updated with {Guid.NewGuid().ToString()}";
}
/// <summary>
///
/// </summary>
/// <param name="table"></param>
/// <returns></returns>
public static dynamic UpdateMdsNonIdentityCompleteTableProperties(MdsNonIdentityCompleteTable table)
{
return(new
{
table.Id,
ColumnBigInt = long.MaxValue,
ColumnBlob = Encoding.UTF32.GetBytes(Guid.NewGuid().ToString()),
ColumnBoolean = true,
ColumnChar = char.Parse("C").ToString(),
ColumnDate = DateTime.SpecifyKind(DateTime.UtcNow, DateTimeKind.Unspecified).Date,
ColumnDateTime = DateTime.SpecifyKind(DateTime.UtcNow, DateTimeKind.Unspecified),
ColumnDecimal = Convert.ToDecimal(Randomizer.Next(1000000)),
ColumnDouble = Convert.ToDouble(Randomizer.Next(1000000)),
ColumnInt = Randomizer.Next(1000000),
ColumnInteger = Convert.ToInt64(Randomizer.Next(1000000)),
ColumnNumeric = Convert.ToDecimal(Randomizer.Next(1000000)),
ColumnReal = Convert.ToSingle(Randomizer.Next(1000000)),
ColumnString = $"{table.ColumnString} - Updated with {Guid.NewGuid()}",
ColumnText = $"{table.ColumnText} - Updated with {Guid.NewGuid()}",
ColumnTime = DateTime.SpecifyKind(DateTime.UtcNow, DateTimeKind.Unspecified),
ColumnVarChar = $"{table.ColumnVarChar} - Updated with {Guid.NewGuid()}"
});
}
