public void CastToDateTime(string s, int year, int month, int day, int hour, int minute, int second, int millis,
int?offsetHour, int?offsetMinute)
{
var type = PrimitiveTypes.String();
var value = new SqlString(s);
var casted = type.CastTo(value, PrimitiveTypes.DateTime());
Assert.IsNotNull(casted);
Assert.IsInstanceOf <SqlDateTime>(casted);
var date = (SqlDateTime)casted;
Assert.AreEqual(year, date.Year);
Assert.AreEqual(month, date.Month);
Assert.AreEqual(day, date.Day);
Assert.AreEqual(hour, date.Hour);
Assert.AreEqual(minute, date.Minute);
Assert.AreEqual(second, date.Second);
Assert.AreEqual(millis, date.Millisecond);
var offset = (offsetHour != null && offsetMinute != null)
? new SqlDayToSecond(0, offsetHour.Value, offsetMinute.Value, 0)
: SqlDayToSecond.Zero;
Assert.AreEqual(offset, date.Offset);
}
public static SqlType Deserialize(BinaryReader reader, ITypeResolver resolver)
{
var typeCode = (SqlTypeCode)reader.ReadByte();
if (BooleanType.IsBooleanType(typeCode))
{
return(PrimitiveTypes.Boolean(typeCode));
}
if (IntervalType.IsIntervalType(typeCode))
{
return(PrimitiveTypes.Interval(typeCode));
}
if (DateType.IsDateType(typeCode))
{
return(PrimitiveTypes.DateTime(typeCode));
}
if (StringType.IsStringType(typeCode))
{
var maxSize = reader.ReadInt32();
CultureInfo locale = null;
var hasLocale = reader.ReadByte() == 1;
if (hasLocale)
{
var name = reader.ReadString();
locale = new CultureInfo(name);
}
// TODO: Get the encoding from the serialization...
return(PrimitiveTypes.String(typeCode, maxSize, Encoding.Unicode, locale));
}
if (NumericType.IsNumericType(typeCode))
{
var size = reader.ReadInt32();
var scale = reader.ReadInt32();
return(PrimitiveTypes.Numeric(typeCode, size, scale));
}
if (BinaryType.IsBinaryType(typeCode))
{
var size = reader.ReadInt32();
return(PrimitiveTypes.Binary(typeCode, size));
}
if (typeCode == SqlTypeCode.Type)
{
// TODO:
}
if (typeCode == SqlTypeCode.QueryPlan)
{
return(new QueryType());
}
if (typeCode == SqlTypeCode.Array)
{
var size = reader.ReadInt32();
return(new ArrayType(size));
}
if (typeCode == SqlTypeCode.Null)
{
return(PrimitiveTypes.Null());
}
throw new NotSupportedException();
}