public void BasicVarChar_Create() { const string s = "Test string"; var sObj = DataObject.VarChar(s); Assert.IsNotNull(sObj); Assert.IsInstanceOf <DataObject>(sObj); Assert.AreEqual(SqlTypeCode.VarChar, sObj.Type.TypeCode); Assert.IsInstanceOf <SqlString>(sObj.Value); Assert.AreEqual(s, sObj.Value); }
public void BasicVarChar_Compare() { const string s = "Test string"; var sObj1 = DataObject.VarChar(s); var sObj2 = DataObject.VarChar(s); Assert.IsNotNull(sObj1); Assert.IsNotNull(sObj2); Assert.IsTrue(sObj1.IsComparableTo(sObj2)); Assert.AreEqual(0, sObj1.CompareTo(sObj2)); }
public void BasicVarChar_Convert_ToInteger_Fail() { const string s = "fail"; var obj = DataObject.VarChar(s); Assert.IsNotNull(obj); Assert.IsInstanceOf <StringType>(obj.Type); Assert.AreEqual(SqlTypeCode.VarChar, obj.Type.TypeCode); DataObject result = null; Assert.DoesNotThrow(() => result = obj.CastTo(PrimitiveTypes.Numeric(SqlTypeCode.Integer))); Assert.IsNotNull(result); Assert.IsInstanceOf <NumericType>(result.Type); Assert.IsTrue(result.IsNull); }
public void BasicVarChar_Convert_ToBoolean_Success() { const string s = "true"; var obj = DataObject.VarChar(s); Assert.IsNotNull(obj); Assert.IsInstanceOf <StringType>(obj.Type); Assert.AreEqual(SqlTypeCode.VarChar, obj.Type.TypeCode); DataObject result = null; Assert.DoesNotThrow(() => result = obj.CastTo(PrimitiveTypes.Boolean())); Assert.IsNotNull(result); Assert.IsInstanceOf <BooleanType>(result.Type); Assert.IsFalse(result.IsNull); Assert.AreEqual(true, (bool)result); }
public void BasicVarChar_Add() { const string s1 = "First test string that comes "; const string s2 = "before the second test string"; var sObj1 = DataObject.VarChar(s1); var sObj2 = DataObject.VarChar(s2); Assert.IsNotNull(sObj1); Assert.IsNotNull(sObj2); Assert.IsTrue(sObj1.IsComparableTo(sObj2)); DataObject result = null; Assert.DoesNotThrow(() => result = sObj1.Add(sObj2)); Assert.IsNotNull(result); Assert.AreEqual("First test string that comes before the second test string", (string)result); }
public override DataObject GetValue(long rowNumber, int columnOffset) { if (rowNumber < 0 || rowNumber >= privBits.Count) { throw new ArgumentOutOfRangeException("rowNumber"); } var pair = privBits[(int)rowNumber]; switch (columnOffset) { case 0: return(DataObject.Integer(pair.Value)); case 1: return(DataObject.VarChar(pair.Key)); default: throw new ArgumentOutOfRangeException("columnOffset"); } }