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 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 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 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 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 ()); }