public void TimeSpanMembers() { DbBoundType newed_item = new DbBoundType(); newed_item.PublicTimeSpanField = new TimeSpan(0, 0, 1); newed_item.PublicTimeSpanProperty = new TimeSpan(1, 0, 0); newed_item.SetPrivateTimeSpanField(new TimeSpan(1, 39, 12)); newed_item.SetPrivateTimeSpanProperty(TimeSpan.MinValue); provider.Save(newed_item); string command = String.Format("SELECT PrivateTimeSpanProperty FROM {0} WHERE PrimaryKey = {1}", provider.TableName, newed_item.PrimaryKey); using (IDataReader reader = connection.Query(command)) { reader.Read(); Assert.IsTrue(reader.IsDBNull(0)); } // NUnit boxes and uses reference equality, rather than Equals() DbBoundType loaded_item = provider.FetchSingle(newed_item.PrimaryKey); Assert.AreEqual(newed_item.PublicTimeSpanField, loaded_item.PublicTimeSpanField); Assert.AreEqual(newed_item.PublicTimeSpanProperty, loaded_item.PublicTimeSpanProperty); Assert.AreEqual(newed_item.GetPrivateTimeSpanField(), loaded_item.GetPrivateTimeSpanField()); Assert.AreEqual(newed_item.GetPrivateTimeSpanProperty(), loaded_item.GetPrivateTimeSpanProperty()); }
public void DateTimeMembers() { DbBoundType newed_item = new DbBoundType(); newed_item.PublicDateTimeField = DateTime.Now; newed_item.PublicDateTimeProperty = new DateTime(1986, 4, 23); newed_item.SetPrivateDateTimeField(DateTime.MinValue); newed_item.SetPrivateDateTimeProperty(DateTime.Now); provider.Save(newed_item); string command = String.Format("SELECT PrivateDateTimeField FROM {0} WHERE PrimaryKey = {1}", provider.TableName, newed_item.PrimaryKey); using (IDataReader reader = connection.Query(command)) { reader.Read(); Assert.IsTrue(reader.IsDBNull(0)); } DbBoundType loaded_item = provider.FetchSingle(newed_item.PrimaryKey); AssertArePrettyClose(newed_item.PublicDateTimeField, loaded_item.PublicDateTimeField); AssertArePrettyClose(newed_item.PublicDateTimeProperty, loaded_item.PublicDateTimeProperty); AssertArePrettyClose(newed_item.GetPrivateDateTimeField(), loaded_item.GetPrivateDateTimeField()); AssertArePrettyClose(newed_item.GetPrivateDateTimeProperty(), loaded_item.GetPrivateDateTimeProperty()); }
public void StringMembers() { DbBoundType newed_item = new DbBoundType(); newed_item.PublicStringField = "Surely you're joking, Mr. Feynman."; newed_item.PublicStringProperty = "Even as a splitted bark, so sunder we: This way fall I to death."; newed_item.SetPrivateStringField("Who is John Galt?"); newed_item.SetPrivateStringProperty("The most formidable weapon against errors of every kind is Reason."); provider.Save(newed_item); DbBoundType loaded_item = provider.FetchSingle(newed_item.PrimaryKey); Assert.AreEqual(newed_item.PublicStringField, loaded_item.PublicStringField); Assert.AreEqual(newed_item.PublicStringProperty, loaded_item.PublicStringProperty); Assert.AreEqual(newed_item.GetPrivateStringField(), loaded_item.GetPrivateStringField()); Assert.AreEqual(newed_item.GetPrivateStringProperty(), loaded_item.GetPrivateStringProperty()); }
public void LongMembers() { DbBoundType newed_item = new DbBoundType(); newed_item.PublicLongField = 4926227057; newed_item.PublicLongProperty = -932; newed_item.SetPrivateLongField(3243); newed_item.SetPrivateLongProperty(1); provider.Save(newed_item); DbBoundType loaded_item = provider.FetchSingle(newed_item.PrimaryKey); Assert.AreEqual(newed_item.PublicLongField, loaded_item.PublicLongField); Assert.AreEqual(newed_item.PublicLongProperty, loaded_item.PublicLongProperty); Assert.AreEqual(newed_item.GetPrivateLongField(), loaded_item.GetPrivateLongField()); Assert.AreEqual(newed_item.GetPrivateLongProperty(), loaded_item.GetPrivateLongProperty()); }
public void IntMembers() { DbBoundType newed_item = new DbBoundType(); newed_item.PublicIntField = 3141592; newed_item.PublicIntProperty = 13; newed_item.SetPrivateIntField(128); newed_item.SetPrivateIntProperty(42); provider.Save(newed_item); DbBoundType loaded_item = provider.FetchSingle(newed_item.PrimaryKey); Assert.AreEqual(newed_item.PublicIntField, loaded_item.PublicIntField); Assert.AreEqual(newed_item.PublicIntProperty, loaded_item.PublicIntProperty); Assert.AreEqual(newed_item.GetPrivateIntField(), loaded_item.GetPrivateIntField()); Assert.AreEqual(newed_item.GetPrivateIntProperty(), loaded_item.GetPrivateIntProperty()); }
public void LongEnumMembers() { DbBoundType newed_item = new DbBoundType(); newed_item.PublicLongEnumField = LongEnum.Cero; newed_item.PublicLongEnumProperty = LongEnum.Uno; newed_item.SetPrivateLongEnumField(LongEnum.Dos); newed_item.SetPrivateLongEnumProperty(LongEnum.Tres); provider.Save(newed_item); DbBoundType loaded_item = provider.FetchSingle(newed_item.PrimaryKey); Assert.AreEqual(newed_item.PublicLongEnumField, loaded_item.PublicLongEnumField); Assert.AreEqual(newed_item.PublicLongEnumProperty, loaded_item.PublicLongEnumProperty); Assert.AreEqual(newed_item.GetPrivateLongEnumField(), loaded_item.GetPrivateLongEnumField()); Assert.AreEqual(newed_item.GetPrivateLongEnumProperty(), loaded_item.GetPrivateLongEnumProperty()); }
public void IntEnumMembers() { DbBoundType newed_item = new DbBoundType(); newed_item.PublicIntEnumField = IntEnum.Zero; newed_item.PublicIntEnumProperty = IntEnum.One; newed_item.SetPrivateIntEnumField(IntEnum.Two); newed_item.SetPrivateIntEnumProperty(IntEnum.Three); provider.Save(newed_item); DbBoundType loaded_item = provider.FetchSingle(newed_item.PrimaryKey); Assert.AreEqual(newed_item.PublicIntEnumField, loaded_item.PublicIntEnumField); Assert.AreEqual(newed_item.PublicIntEnumProperty, loaded_item.PublicIntEnumProperty); Assert.AreEqual(newed_item.GetPrivateIntEnumField(), loaded_item.GetPrivateIntEnumField()); Assert.AreEqual(newed_item.GetPrivateIntEnumProperty(), loaded_item.GetPrivateIntEnumProperty()); }
public void NullStringMembers() { DbBoundType newed_item = new DbBoundType(); newed_item.PublicStringField = null; newed_item.PublicStringProperty = null; newed_item.SetPrivateStringField(null); newed_item.SetPrivateStringProperty(null); provider.Save(newed_item); DbBoundType loaded_item = provider.FetchSingle(newed_item.PrimaryKey); Assert.AreEqual(newed_item.PublicStringField, loaded_item.PublicStringField); Assert.AreEqual(newed_item.PublicStringProperty, loaded_item.PublicStringProperty); Assert.AreEqual(newed_item.GetPrivateStringField(), loaded_item.GetPrivateStringField()); Assert.AreEqual(newed_item.GetPrivateStringProperty(), loaded_item.GetPrivateStringProperty()); }
public void BlankStringMembers() { DbBoundType newed_item = new DbBoundType(); newed_item.PublicStringField = ""; newed_item.PublicStringProperty = null; newed_item.SetPrivateStringField(" \t "); newed_item.SetPrivateStringProperty(" foo "); provider.Save(newed_item); DbBoundType loaded_item = provider.FetchSingle(newed_item.PrimaryKey); Assert.AreEqual(null, loaded_item.PublicStringField); Assert.AreEqual(null, loaded_item.PublicStringProperty); Assert.AreEqual(null, loaded_item.GetPrivateStringField()); Assert.AreEqual(" foo ", loaded_item.GetPrivateStringProperty()); }