public void SelectMinValues() { int count = DataUtil.CountRows("Binary"); ObjectTransaction transaction = manager.BeginTransaction(); BinaryTestObject test = transaction.Select(typeof(BinaryTestObject), ZeroValues) as BinaryTestObject; Assert.AreEqual(new Guid(ZeroValues), test.Id); Assert.AreEqual(8, test.Binary.Length); foreach (byte b in test.Binary) { Assert.AreEqual(Byte.MinValue, b); } Assert.AreEqual(16, test.VarBinary.Length); foreach (byte b in test.VarBinary) { Assert.AreEqual(Byte.MinValue, b); } Assert.AreEqual(32, test.Image.Length); foreach (byte b in test.Image) { Assert.AreEqual(Byte.MinValue, b); } Assert.AreEqual(count, DataUtil.CountRows("Binary")); }
public void DeleteRandomValues() { Random random = new Random(); int count = DataUtil.CountRows("Binary"); ObjectTransaction transaction = manager.BeginTransaction(); BinaryTestObject test1 = transaction.Create(typeof(BinaryTestObject)) as BinaryTestObject; test1.Binary = new byte[8]; random.NextBytes(test1.Binary); test1.VarBinary = new byte[5]; random.NextBytes(test1.VarBinary); test1.Image = new byte[1024]; random.NextBytes(test1.Image); transaction.Commit(); Assert.AreEqual(count + 1, DataUtil.CountRows("Binary")); ObjectTransaction transaction2 = manager.BeginTransaction(); BinaryTestObject test2 = transaction2.Select(typeof(BinaryTestObject), test1.Id) as BinaryTestObject; Assert.AreEqual(8, test2.Binary.Length); Assert.AreEqual(5, test2.VarBinary.Length); Assert.AreEqual(1024, test2.Image.Length); transaction2.Delete(test2); transaction2.Commit(); Assert.AreEqual(count, DataUtil.CountRows("Binary")); }
public void UpdateRandomValues() { Random random = new Random(); int count = DataUtil.CountRows("Binary"); ObjectTransaction transaction = manager.BeginTransaction(); BinaryTestObject test1 = transaction.Select(typeof(BinaryTestObject), UpdateValue) as BinaryTestObject; test1.Binary = new Byte[8]; random.NextBytes(test1.Binary); byte b = test1.Binary[3]; test1.VarBinary[2] = 16; test1.Image[1] = 69; transaction.Commit(); Assert.AreEqual(count, DataUtil.CountRows("Binary")); ObjectTransaction transaction2 = manager.BeginTransaction(); BinaryTestObject test2 = transaction2.Select(typeof(BinaryTestObject), UpdateValue) as BinaryTestObject; Assert.AreEqual(b, test2.Binary[3]); Assert.AreEqual(16, test2.VarBinary[2]); Assert.AreEqual(69, test2.Image[1]); transaction2.Commit(); Assert.AreEqual(count, DataUtil.CountRows("Binary")); }
public void SelectNonExistantValues() { int count = DataUtil.CountRows("Binary"); ObjectTransaction transaction = manager.BeginTransaction(); BinaryTestObject test = transaction.Select(typeof(BinaryTestObject), DoesNotExistValues) as BinaryTestObject; Assert.IsNull(test); Assert.AreEqual(count, DataUtil.CountRows("Binary")); }
public void InsertMissingValues() { Random random = new Random(); int count = DataUtil.CountRows("Binary"); ObjectTransaction transaction = manager.BeginTransaction(); BinaryTestObject test = transaction.Create(typeof(BinaryTestObject)) as BinaryTestObject; test.Binary = new byte[8]; random.NextBytes(test.Binary); test.VarBinary = new byte[16]; random.NextBytes(test.VarBinary); transaction.Commit(); Assert.AreEqual(count + 1, DataUtil.CountRows("Binary")); }