private ISqlString ToString(SqlDateTime date, SqlCharacterType destType)
{
var dateString = ToSqlString(date);
var s = new SqlString(dateString);
return((ISqlString)destType.NormalizeValue(s));
}
public static void GetTypeString(SqlTypeCode typeCode, int maxSize, string locale, string expected)
{
var culture = String.IsNullOrEmpty(locale) ? null : new CultureInfo(locale);
var type = new SqlCharacterType(typeCode, maxSize, culture);
var sql = type.ToString();
Assert.Equal(expected, sql);
}
public static void Serialize(SqlTypeCode typeCode, int maxSize, string locale)
{
var culture = String.IsNullOrEmpty(locale) ? null : new CultureInfo(locale);
var type = new SqlCharacterType(typeCode, maxSize, culture);
var result = BinarySerializeUtil.Serialize(type);
Assert.Equal(type, result);
}
public static void Greater(string s1, string s2, string locale, bool expected)
{
var sqlString1 = new SqlString(s1);
var sqlString2 = new SqlString(s2);
var culture = String.IsNullOrEmpty(locale) ? null : new CultureInfo(locale);
var type = new SqlCharacterType(SqlTypeCode.String, -1, culture);
Assert.Equal(expected, (bool)type.Greater(sqlString1, sqlString2));
}
private static void InvalidOp(Func <SqlType, Func <ISqlValue, ISqlValue> > selector)
{
var s1 = new SqlString("foo");
var type = new SqlCharacterType(SqlTypeCode.String, -1, null);
var op = selector(type);
var result = op(s1);
Assert.NotNull(result);
Assert.IsType <SqlNull>(result);
}
private ISqlValue ToString(SqlNumber number, SqlCharacterType destType)
{
if (destType.HasMaxSize && number.Precision > destType.MaxSize)
{
return(SqlNull.Value);
}
var s = number.ToString();
return(destType.NormalizeValue(new SqlString(s)));
}
private ISqlValue ToString(ISqlBinary binary, SqlCharacterType destType)
{
if (binary == null)
{
throw new InvalidCastException();
}
var bytes = binary.ToArray();
var s = new SqlString(bytes);
return(destType.NormalizeValue(s));
}
public static void CreateStringType(SqlTypeCode typeCode, int maxSize, string locale)
{
var culture = String.IsNullOrEmpty(locale) ? null : new CultureInfo(locale);
var type = new SqlCharacterType(typeCode, maxSize, culture);
Assert.Equal(typeCode, type.TypeCode);
Assert.Equal(maxSize, type.MaxSize);
Assert.Equal(maxSize > 0, type.HasMaxSize);
Assert.Equal(locale, type.Locale == null ? null : type.Locale.Name);
Assert.True(type.IsIndexable);
Assert.False(type.IsReference);
Assert.False(type.IsLargeObject);
Assert.True(type.IsPrimitive);
}
public static void CastToString(string s, SqlTypeCode typeCode, SqlTypeCode destTypeCode, int maxSize, string expected)
{
var date = SqlDateTime.Parse(s);
var type = new SqlDateTimeType(typeCode);
var destType = new SqlCharacterType(destTypeCode, maxSize, null);
Assert.True(type.CanCastTo(date, destType));
var result = type.Cast(date, destType);
Assert.NotNull(result);
Assert.IsType <SqlString>(result);
Assert.Equal(expected, (SqlString)result);
}
public static void CastToString(string s, SqlTypeCode typeCode, int maxSize, string expected)
{
var type = new SqlBinaryType(SqlTypeCode.Binary);
var input = (SqlString)s;
var destType = new SqlCharacterType(typeCode, maxSize, null);
var bytes = input.ToByteArray();
var binary = new SqlBinary(bytes);
Assert.True(type.CanCastTo(binary, destType));
var result = type.Cast(binary, destType);
Assert.NotNull(result);
Assert.IsType <SqlString>(result);
Assert.Equal(expected, (SqlString)result);
}
private ISqlString ToString(SqlBoolean value, SqlCharacterType destType)
{
var s = new SqlString(ToSqlString(value));
return((ISqlString)destType.NormalizeValue(s));
}
private ISqlValue ToString(SqlDayToSecond dts, SqlCharacterType destType)
{
var s = new SqlString(dts.ToString());
return(destType.NormalizeValue(s));
}
