public void TestNullableViaResultClass2() { NullableClass clazz = new NullableClass(); clazz.TestBool = true; clazz.TestByte = 155; clazz.TestChar = 'a'; DateTime? date = new DateTime?(DateTime.Now); clazz.TestDateTime = date; clazz.TestDecimal = 99.53M; clazz.TestDouble = 99.5125; Guid? guid = new Guid?(Guid.NewGuid()); clazz.TestGuid = guid; clazz.TestInt16 = 45; clazz.TestInt32 = 99; clazz.TestInt64 = 1234567890123456789; clazz.TestSingle = 4578.46445454112f; dataMapper.Insert("InsertNullable", clazz); clazz = null; clazz = dataMapper.QueryForObject<NullableClass>("GetClassNullable", 1); Assert.IsNotNull(clazz); Assert.AreEqual(1, clazz.Id); Assert.IsTrue(clazz.TestBool.Value); Assert.AreEqual(155, clazz.TestByte); Assert.AreEqual('a', clazz.TestChar); Assert.AreEqual(date.Value.ToString(), clazz.TestDateTime.Value.ToString()); Assert.AreEqual(99.53M, clazz.TestDecimal); Assert.AreEqual(99.5125, clazz.TestDouble); Assert.AreEqual(guid, clazz.TestGuid); Assert.AreEqual(45, clazz.TestInt16); Assert.AreEqual(99, clazz.TestInt32); Assert.AreEqual(1234567890123456789, clazz.TestInt64); Assert.AreEqual(4578.46445454112f, clazz.TestSingle); }
public void TestNullableViaResultClass() { NullableClass clazz = new NullableClass(); dataMapper.Insert("InsertNullable", clazz); clazz = null; clazz = dataMapper.QueryForObject<NullableClass>("GetClassNullable", 1); Assert.IsNotNull(clazz); Assert.AreEqual(1, clazz.Id); Assert.IsNull(clazz.TestBool); Assert.IsNull(clazz.TestByte); Assert.IsNull(clazz.TestChar); Assert.IsNull(clazz.TestDateTime); Assert.IsNull(clazz.TestDecimal); Assert.IsNull(clazz.TestDouble); Assert.IsNull(clazz.TestGuid); Assert.IsNull(clazz.TestInt16); Assert.IsNull(clazz.TestInt32); Assert.IsNull(clazz.TestInt64); Assert.IsNull(clazz.TestSingle); }
public void TestNotNullableTimeSpan() { NullableClass clazz = new NullableClass(); TimeSpan? span = new TimeSpan?(new TimeSpan(1, 2, 3, 4, 5)); clazz.TestTimeSpan = span; dataMapper.Insert("InsertNullable", clazz); clazz = null; clazz = dataMapper.QueryForObject<NullableClass>("GetNullable", 1); Assert.IsNotNull(clazz); Assert.AreEqual(1, clazz.Id); Assert.AreEqual(span.Value.ToString(), clazz.TestTimeSpan.Value.ToString()); }
public void TestNullableTimeSpan() { NullableClass clazz = new NullableClass(); dataMapper.Insert("InsertNullable", clazz); clazz = null; clazz = dataMapper.QueryForObject<NullableClass>("GetNullable", 1); Assert.IsNotNull(clazz); Assert.AreEqual(1, clazz.Id); Assert.IsNull(clazz.TestTimeSpan); }
public void TestNotNullableSingle() { NullableClass clazz = new NullableClass(); clazz.TestSingle = 4578.46445454112f; dataMapper.Insert("InsertNullable", clazz); clazz = null; clazz = dataMapper.QueryForObject<NullableClass>("GetNullable", 1); Assert.IsNotNull(clazz); Assert.AreEqual(1, clazz.Id); Assert.AreEqual(4578.46445454112f, clazz.TestSingle); }
public void TestNotNullableInt64() { NullableClass clazz = new NullableClass(); clazz.TestInt64 = 1234567890123456789; dataMapper.Insert("InsertNullable", clazz); clazz = null; clazz = dataMapper.QueryForObject<NullableClass>("GetNullable", 1); Assert.IsNotNull(clazz); Assert.AreEqual(1, clazz.Id); Assert.AreEqual(1234567890123456789, clazz.TestInt64); }
public void TestNotNullableInt16() { NullableClass clazz = new NullableClass(); clazz.TestInt16 = 45; dataMapper.Insert("InsertNullable", clazz); clazz = null; clazz = dataMapper.QueryForObject<NullableClass>("GetNullable", 1); Assert.IsNotNull(clazz); Assert.AreEqual(1, clazz.Id); Assert.AreEqual(45, clazz.TestInt16); }
public void TestNotNullableGuid() { NullableClass clazz = new NullableClass(); Guid? guid = new Guid?(Guid.NewGuid()); clazz.TestGuid = guid; dataMapper.Insert("InsertNullable", clazz); clazz = null; clazz = dataMapper.QueryForObject<NullableClass>("GetNullable", 1); Assert.IsNotNull(clazz); Assert.AreEqual(1, clazz.Id); Assert.AreEqual(guid, clazz.TestGuid); }
public void TestNotNullableDouble() { NullableClass clazz = new NullableClass(); clazz.TestDouble = 99.5125; dataMapper.Insert("InsertNullable", clazz); clazz = null; clazz = dataMapper.QueryForObject<NullableClass>("GetNullable", 1); Assert.IsNotNull(clazz); Assert.AreEqual(1, clazz.Id); Assert.AreEqual(99.5125, clazz.TestDouble); }
public void TestNotNullableDateTime() { NullableClass clazz = new NullableClass(); DateTime? date = new DateTime?(DateTime.Now); clazz.TestDateTime = date; dataMapper.Insert("InsertNullable", clazz); clazz = null; clazz = dataMapper.QueryForObject<NullableClass>("GetNullable", 1); Assert.IsNotNull(clazz); Assert.AreEqual(1, clazz.Id); Assert.AreEqual(date.Value.ToString(), clazz.TestDateTime.Value.ToString()); }
public void TestNotNullableChar() { NullableClass clazz = new NullableClass(); clazz.TestChar = 'a'; dataMapper.Insert("InsertNullable", clazz); clazz = null; clazz = dataMapper.QueryForObject<NullableClass>("GetNullable", 1); Assert.IsNotNull(clazz); Assert.AreEqual(1, clazz.Id); Assert.AreEqual('a', clazz.TestChar); }
public void TestNotNullableBool() { NullableClass clazz = new NullableClass(); clazz.TestBool = false; dataMapper.Insert("InsertNullable", clazz); clazz = null; clazz = dataMapper.QueryForObject<NullableClass>("GetNullable", 1); Assert.IsNotNull(clazz); Assert.AreEqual(1, clazz.Id); Assert.AreEqual(false, clazz.TestBool); }