public void DeleteRandomValues() { int count = DataUtil.CountRows("FloatingPointNumbers"); ObjectTransaction transaction1 = manager.BeginTransaction(); FloatingPointNumberTestObject test1 = transaction1.Create(typeof(FloatingPointNumberTestObject)) as FloatingPointNumberTestObject; test1.Decimal = 1.565m; test1.Numeric = 565m; test1.Float = -1.25; test1.Real = 126; test1.Money = -65.65m; test1.SmallMoney = 23.545m; transaction1.Commit(); Assert.AreEqual(count + 1, DataUtil.CountRows("FloatingPointNumbers")); ObjectTransaction transaction2 = manager.BeginTransaction(); FloatingPointNumberTestObject test2 = transaction2.Select(typeof(FloatingPointNumberTestObject), test1.Id) as FloatingPointNumberTestObject; Assert.AreEqual(2, test2.Decimal); Assert.AreEqual(565, test2.Numeric); Assert.AreEqual(-1.25, test2.Float); Assert.AreEqual(126, test2.Real); Assert.AreEqual(-65.65m, test2.Money); Assert.AreEqual(23.545m, test2.SmallMoney); transaction2.Delete(test2); transaction2.Commit(); Assert.AreEqual(count, DataUtil.CountRows("FloatingPointNumbers")); }
public void SelectNonExistantValues() { int count = DataUtil.CountRows("FloatingPointNumbers"); ObjectTransaction transaction = manager.BeginTransaction(); FloatingPointNumberTestObject test = transaction.Select(typeof(FloatingPointNumberTestObject), DoesNotExistValues) as FloatingPointNumberTestObject; Assert.IsNull(test); Assert.AreEqual(count, DataUtil.CountRows("FloatingPointNumbers")); }
public void SelectZeroValues() { int count = DataUtil.CountRows("FloatingPointNumbers"); ObjectTransaction transaction = manager.BeginTransaction(); FloatingPointNumberTestObject test = transaction.Select(typeof(FloatingPointNumberTestObject), ZeroValues) as FloatingPointNumberTestObject; Assert.AreEqual(new Guid(ZeroValues), test.Id); Assert.AreEqual(0, test.Decimal); Assert.AreEqual(0, test.Numeric); Assert.AreEqual(0, test.Float); Assert.AreEqual(0, test.Real); Assert.AreEqual(0, test.Money); Assert.AreEqual(0, test.SmallMoney); Assert.AreEqual(count, DataUtil.CountRows("FloatingPointNumbers")); }
public void SelectMinValues() { int count = DataUtil.CountRows("FloatingPointNumbers"); ObjectTransaction transaction = manager.BeginTransaction(); FloatingPointNumberTestObject test = transaction.Select(typeof(FloatingPointNumberTestObject), MinValues) as FloatingPointNumberTestObject; Assert.AreEqual(new Guid(MinValues), test.Id); Assert.AreEqual(Decimal.MinValue, test.Decimal); Assert.AreEqual(Decimal.MinValue, test.Numeric); Assert.AreEqual(Double.MinValue, test.Float); Assert.AreEqual(Single.MinValue, test.Real); Assert.AreEqual(-922337203685477.5807m, test.Money); Assert.AreEqual(-214748.3647m, test.SmallMoney); Assert.AreEqual(count, DataUtil.CountRows("FloatingPointNumbers")); }
public void InsertMissingValues() { int count = DataUtil.CountRows("FloatingPointNumbers"); ObjectTransaction transaction = manager.BeginTransaction(); FloatingPointNumberTestObject test = transaction.Create(typeof(FloatingPointNumberTestObject)) as FloatingPointNumberTestObject; test.Decimal = 5.1m; test.Numeric = 6.6m; test.Float = -9.6; test.Money = 45.65m; test.SmallMoney = -56.1m; transaction.Commit(); Assert.AreEqual(count + 1, DataUtil.CountRows("FloatingPointNumbers")); }
public void UpdateValues() { int count = DataUtil.CountRows("FloatingPointNumbers"); ObjectTransaction transaction = manager.BeginTransaction(); FloatingPointNumberTestObject test1 = transaction.Select(typeof(FloatingPointNumberTestObject), UpdateValue) as FloatingPointNumberTestObject; Assert.AreEqual(new Guid(UpdateValue), test1.Id); Assert.AreEqual(1, test1.Decimal); Assert.AreEqual(1, test1.Numeric); Assert.AreEqual(1, test1.Float); Assert.AreEqual(1, test1.Real); Assert.AreEqual(1, test1.Money); Assert.AreEqual(1, test1.SmallMoney); test1.Decimal = 2m; test1.Numeric = 6m; test1.Float = -6.9; test1.Real = -8.56f; test1.Money = 69.69m; test1.SmallMoney = -45.45m; transaction.Commit(); Assert.AreEqual(count, DataUtil.CountRows("FloatingPointNumbers")); ObjectTransaction transaction2 = manager.BeginTransaction(); FloatingPointNumberTestObject test2 = transaction2.Select(typeof(FloatingPointNumberTestObject), UpdateValue) as FloatingPointNumberTestObject; Assert.AreEqual(new Guid(UpdateValue), test2.Id); Assert.AreEqual(2, test2.Decimal); Assert.AreEqual(6, test2.Numeric); Assert.AreEqual(-6.9, test2.Float); Assert.AreEqual(-8.56, test2.Real); Assert.AreEqual(69.69m, test2.Money); Assert.AreEqual(-45.45m, test2.SmallMoney); Assert.AreEqual(count, DataUtil.CountRows("FloatingPointNumbers")); }