public void GetRawValue()
{
SqlType type = new SqlTime(testValue, 2, ParameterDirection.Input);
Assert.AreEqual(testValue, type.GetRawValue());
type = new SqlTime(null, 1, ParameterDirection.Input);
Assert.Null(type.GetRawValue());
}
public void GetRawValue()
{
SqlType type = new SqlTime(testValue, 2, ParameterDirection.Input);
Assert.AreEqual(testValue, type.GetRawValue());
type = new SqlTime(null, 1, ParameterDirection.Input);
Assert.Null(type.GetRawValue());
}
public void CreateMetaData()
{
Assert.Throws<TypeCannotBeUsedAsAClrTypeException>(() => SqlTime.GetTypeHandler().CreateMetaData("Test"));
SqlTypeHandler col = new SqlTime(testValue, null, ParameterDirection.Input);
Assert.Throws<TypePropertiesMustBeSetExplicitlyException>(() => col.CreateMetaData("Test"));
col = new SqlTime(testValue, 6, ParameterDirection.Input);
var meta = col.CreateMetaData("Test");
Assert.AreEqual(SqlDbType.Time, meta.SqlDbType);
Assert.AreEqual(6, meta.Scale);
Assert.AreEqual("Test", meta.Name);
}
public void GetValue()
{
// time(0)
var time0 = new SqlTime(0, CompressionContext.NoCompression);
var input0 = new byte[] { 0xf9, 0x9f, 0x00 };
Assert.AreEqual(new TimeSpan(11, 22, 33), (TimeSpan)time0.GetValue(input0));
// time(1)
var time1 = new SqlTime(1, CompressionContext.NoCompression);
var input1 = new byte[] { 0xbb, 0x3f, 0x06 };
Assert.AreEqual(new TimeSpan(0, 11, 22, 33, 1), (TimeSpan)time1.GetValue(input1));
// time(2)
var time2 = new SqlTime(2, CompressionContext.NoCompression);
var input2 = new byte[] { 0x50, 0x7d, 0x3e };
Assert.AreEqual(new TimeSpan(0, 11, 22, 33, 12), (TimeSpan)time2.GetValue(input2));
// time(3)
var time3 = new SqlTime(3, CompressionContext.NoCompression);
var input3 = new byte[] { 0x23, 0xe5, 0x70, 0x02 };
Assert.AreEqual(new TimeSpan(0, 11, 22, 33, 123), (TimeSpan)time3.GetValue(input3));
// time(4)
var time4 = new SqlTime(4, CompressionContext.NoCompression);
var input4 = new byte[] { 0x63, 0xf3, 0x68, 0x18 };
Assert.AreEqual(new TimeSpan(0, 11, 22, 33, 1235), (TimeSpan)time4.GetValue(input4));
// time(5)
var time5 = new SqlTime(5, CompressionContext.NoCompression);
var input5 = new byte[] { 0xda, 0x81, 0x19, 0xf4, 0x00 };
Assert.AreEqual(new TimeSpan(0, 11, 22, 33, 12346), (TimeSpan)time5.GetValue(input5));
// time(6)
var time6 = new SqlTime(6, CompressionContext.NoCompression);
var input6 = new byte[] { 0x81, 0x12, 0xff, 0x88, 0x09 };
Assert.AreEqual(new TimeSpan(0, 11, 22, 33, 123457), (TimeSpan)time6.GetValue(input6));
// time(7)
var time7 = new SqlTime(7, CompressionContext.NoCompression);
var input7 = new byte[] { 0x07, 0xb9, 0xf6, 0x59, 0x5f };
Assert.AreEqual(new TimeSpan(0, 11, 22, 33, 1234567), (TimeSpan)time7.GetValue(input7));
}
public void CreateMetaData()
{
Assert.Throws <TypeCannotBeUsedAsAClrTypeException>(() => SqlTime.GetTypeHandler().CreateMetaData("Test"));
SqlTypeHandler col = new SqlTime(testValue, null, ParameterDirection.Input);
Assert.Throws <TypePropertiesMustBeSetExplicitlyException>(() => col.CreateMetaData("Test"));
col = new SqlTime(testValue, 6, ParameterDirection.Input);
var meta = col.CreateMetaData("Test");
Assert.AreEqual(SqlDbType.Time, meta.SqlDbType);
Assert.AreEqual(6, meta.Scale);
Assert.AreEqual("Test", meta.Name);
}
protected override string GetColumnCreationMethod(SqlColumn column)
{
var type = column.Types[Version];
return(type.SqlTypeInfo switch
{
SqlChar _ => $"{nameof(Generic1Columns.AddChar)}(\"{column.Name}\", {type.Length?.ToString("D", CultureInfo.InvariantCulture)}",
SqlNChar _ => $"{nameof(Generic1Columns.AddNChar)}(\"{column.Name}\", {type.Length?.ToString("D", CultureInfo.InvariantCulture)}, {type.IsNullable.ToString(CultureInfo.InvariantCulture)}",
SqlVarChar _ => $"{nameof(Generic1Columns.AddVarChar)}(\"{column.Name}\", {type.Length?.ToString("D", CultureInfo.InvariantCulture)}, {type.IsNullable.ToString(CultureInfo.InvariantCulture)}",
SqlNVarChar _ => $"{nameof(Generic1Columns.AddNVarChar)}(\"{column.Name}\", {type.Length?.ToString("D", CultureInfo.InvariantCulture)}, {type.IsNullable.ToString(CultureInfo.InvariantCulture)}",
SqlFloatSmall _ => $"{nameof(Generic1Columns.AddFloatSmall)}(\"{column.Name}\", {type.IsNullable.ToString(CultureInfo.InvariantCulture)}",
SqlFloatLarge _ => $"{nameof(Generic1Columns.AddFloatLarge)}(\"{column.Name}\", {type.IsNullable.ToString(CultureInfo.InvariantCulture)}",
SqlBit _ => $"{nameof(Generic1Columns.AddBit)}(\"{column.Name}\", {type.IsNullable.ToString(CultureInfo.InvariantCulture)}",
SqlByte _ => $"{nameof(Generic1Columns.AddByte)}(\"{column.Name}\", {type.IsNullable.ToString(CultureInfo.InvariantCulture)}",
SqlInt16 _ => $"{nameof(Generic1Columns.AddInt16)}(\"{column.Name}\", {type.IsNullable.ToString(CultureInfo.InvariantCulture)}",
SqlInt32 _ => $"{nameof(Generic1Columns.AddInt32)}(\"{column.Name}\", {type.IsNullable.ToString(CultureInfo.InvariantCulture)}",
SqlInt64 _ => $"{nameof(Generic1Columns.AddInt64)}(\"{column.Name}\", {type.IsNullable.ToString(CultureInfo.InvariantCulture)}",
SqlNumber _ => $"{nameof(Generic1Columns.AddNumber)}(\"{column.Name}\", {type.Length?.ToString("D", CultureInfo.InvariantCulture)}, {type.Scale?.ToString("D", CultureInfo.InvariantCulture)}, {type.IsNullable.ToString(CultureInfo.InvariantCulture)}",
SqlDate _ => $"{nameof(Generic1Columns.AddDate)}(\"{column.Name}\", {type.IsNullable.ToString(CultureInfo.InvariantCulture)}",
SqlTime _ => $"{nameof(Generic1Columns.AddTime)}(\"{column.Name}\", {type.IsNullable.ToString(CultureInfo.InvariantCulture)}",
SqlDateTime _ => $"{nameof(Generic1Columns.AddDateTime)}(\"{column.Name}\", {type.IsNullable.ToString(CultureInfo.InvariantCulture)}",
_ => throw new NotImplementedException($"Unmapped type: {type.SqlTypeInfo}"),
});
public void CreateParamFromValue()
{
Assert.Throws <TypeCannotBeUsedAsAClrTypeException>(() => SqlTime.GetTypeHandler().CreateParamFromValue("Test", null));
}
public void GetTypeHandler()
{
Assert.IsInstanceOf <SqlTypeHandler>(SqlTime.GetTypeHandler());
}