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