public void DeleteRandomValues()
{
int count = DataUtil.CountRows("NullableCharacters");
ObjectTransaction transaction1 = manager.BeginTransaction();
NullableCharacterTestObject test1 = transaction1.Create(typeof(NullableCharacterTestObject)) as NullableCharacterTestObject;
test1.Char = "z";
test1.NChar = "z";
test1.VChar = "zzz";
test1.NVChar = "zzz";
test1.Text = "zzz";
test1.NText = "zzz";
transaction1.Commit();
Assert.AreEqual(count + 1, DataUtil.CountRows("NullableCharacters"));
ObjectTransaction transaction2 = manager.BeginTransaction();
NullableCharacterTestObject test2 = transaction2.Select(typeof(NullableCharacterTestObject), test1.Id) as NullableCharacterTestObject;
Assert.AreEqual(test1.Id, test2.Id);
Assert.AreEqual("z", test2.Char);
Assert.AreEqual("z", test2.NChar);
Assert.AreEqual("zzz", test2.VChar);
Assert.AreEqual("zzz", test2.NVChar);
Assert.AreEqual("zzz", test2.Text);
Assert.AreEqual("zzz", test2.NText);
transaction2.Delete(test2);
transaction2.Commit();
Assert.AreEqual(count, DataUtil.CountRows("NullableCharacters"));
}
public void InsertNullExplicitValues()
{
int count = DataUtil.CountRows("NullableCharacters");
ObjectTransaction transaction1 = manager.BeginTransaction();
NullableCharacterTestObject test1 = transaction1.Create(typeof(NullableCharacterTestObject)) as NullableCharacterTestObject;
test1.Char = "x";
test1.NChar = "z";
test1.VChar = "<null value>";
test1.NVChar = "<null n value>";
test1.Text = "<null text value>";
test1.NText = "<null ntext value>";
transaction1.Commit();
Assert.AreEqual(count + 1, DataUtil.CountRows("NullableCharacters"));
Assert.IsTrue(DataUtil.IsRowNull("NullableCharacters", "id", test1.Id));
ObjectTransaction transaction2 = manager.BeginTransaction();
NullableCharacterTestObject test2 = transaction2.Select(typeof(NullableCharacterTestObject), test1.Id) as NullableCharacterTestObject;
Assert.AreEqual("x", test2.Char);
Assert.AreEqual("z", test2.NChar);
Assert.AreEqual("<null value>", test2.VChar);
Assert.AreEqual("<null n value>", test2.NVChar);
Assert.AreEqual("<null text value>", test2.Text);
Assert.AreEqual("<null ntext value>", test2.NText);
}
public void SelectNonExistantValues()
{
int count = DataUtil.CountRows("NullableCharacters");
ObjectTransaction transaction = manager.BeginTransaction();
NullableCharacterTestObject test = transaction.Select(typeof(NullableCharacterTestObject), DoesNotExistValues) as NullableCharacterTestObject;
Assert.IsNull(test);
Assert.AreEqual(count, DataUtil.CountRows("NullableCharacters"));
}
public void CreateNullValues()
{
int count = DataUtil.CountRows("NullableCharacters");
ObjectTransaction transaction = manager.BeginTransaction();
NullableCharacterTestObject test = transaction.Create(typeof(NullableCharacterTestObject)) as NullableCharacterTestObject;
Assert.AreEqual("x", test.Char);
Assert.AreEqual("z", test.NChar);
Assert.AreEqual("<null value>", test.VChar);
Assert.AreEqual("<null n value>", test.NVChar);
Assert.AreEqual("<null text value>", test.Text);
Assert.AreEqual("<null ntext value>", test.NText);
Assert.AreEqual(count, DataUtil.CountRows("NullableCharacters"));
}
public void SelectEmptyValues()
{
int count = DataUtil.CountRows("NullableCharacters");
ObjectTransaction transaction = manager.BeginTransaction();
NullableCharacterTestObject test = transaction.Select(typeof(NullableCharacterTestObject), EmptyValues) as NullableCharacterTestObject;
Assert.AreEqual(new Guid(EmptyValues), test.Id);
Assert.AreEqual(" ", test.Char);
Assert.AreEqual(" ", test.NChar);
Assert.AreEqual(String.Empty, test.VChar);
Assert.AreEqual(String.Empty, test.NVChar);
Assert.AreEqual(String.Empty, test.Text);
Assert.AreEqual(String.Empty, test.NText);
Assert.AreEqual(count, DataUtil.CountRows("NullableCharacters"));
}
public void SelectRandomValues()
{
int count = DataUtil.CountRows("NullableCharacters");
ObjectTransaction transaction = manager.BeginTransaction();
NullableCharacterTestObject test = transaction.Select(typeof(NullableCharacterTestObject), RandomValues) as NullableCharacterTestObject;
Assert.AreEqual(new Guid(RandomValues), test.Id);
Assert.AreEqual("A", test.Char);
Assert.AreEqual("B", test.NChar);
Assert.AreEqual("CDEF", test.VChar);
Assert.AreEqual("GHIJ", test.NVChar);
Assert.AreEqual("LMNOP", test.Text);
Assert.AreEqual("QRSTUV", test.NText);
Assert.AreEqual(count, DataUtil.CountRows("NullableCharacters"));
}
public void InsertRandomValues()
{
int count = DataUtil.CountRows("NullableCharacters");
ObjectTransaction transaction = manager.BeginTransaction();
NullableCharacterTestObject test = transaction.Create(typeof(NullableCharacterTestObject)) as NullableCharacterTestObject;
test.Char = "C";
test.NChar = "X";
test.VChar = "Y";
test.NVChar = "Z";
test.Text = "BGH";
test.NText = "VFG";
transaction.Commit();
Assert.AreEqual(count + 1, DataUtil.CountRows("NullableCharacters"));
}
public void SelectNullValues()
{
int count = DataUtil.CountRows("NullableCharacters");
Assert.IsTrue(DataUtil.IsRowNull("NullableCharacters", "id", NullValues));
ObjectTransaction transaction = manager.BeginTransaction();
NullableCharacterTestObject test = transaction.Select(typeof(NullableCharacterTestObject), NullValues) as NullableCharacterTestObject;
Assert.AreEqual(new Guid(NullValues), test.Id);
Assert.AreEqual("x", test.Char);
Assert.AreEqual("z", test.NChar);
Assert.AreEqual("<null value>", test.VChar);
Assert.AreEqual("<null n value>", test.NVChar);
Assert.AreEqual("<null text value>", test.Text);
Assert.AreEqual("<null ntext value>", test.NText);
Assert.AreEqual(count, DataUtil.CountRows("NullableCharacters"));
}
public void UpdateValues()
{
int count = DataUtil.CountRows("NullableCharacters");
ObjectTransaction transaction = manager.BeginTransaction();
NullableCharacterTestObject test1 = transaction.Select(typeof(NullableCharacterTestObject), UpdateValue) as NullableCharacterTestObject;
Assert.AreEqual(new Guid(UpdateValue), test1.Id);
Assert.AreEqual("X", test1.Char);
Assert.AreEqual("X", test1.NChar);
Assert.AreEqual("XXX", test1.VChar);
Assert.AreEqual("XXX", test1.NVChar);
Assert.AreEqual("XXX", test1.Text);
Assert.AreEqual("XXX", test1.NText);
test1.Char = "Y";
test1.NChar = "Y";
test1.VChar = "YYY";
test1.NVChar = "YYY";
test1.Text = "YYY";
test1.NText = "YYY";
transaction.Commit();
Assert.AreEqual(count, DataUtil.CountRows("NullableCharacters"));
ObjectTransaction transaction2 = manager.BeginTransaction();
NullableCharacterTestObject test2 = transaction2.Select(typeof(NullableCharacterTestObject), UpdateValue) as NullableCharacterTestObject;
Assert.AreEqual(new Guid(UpdateValue), test2.Id);
Assert.AreEqual("Y", test2.Char);
Assert.AreEqual("Y", test2.NChar);
Assert.AreEqual("YYY", test2.VChar);
Assert.AreEqual("YYY", test2.NVChar);
Assert.AreEqual("YYY", test2.Text);
Assert.AreEqual("YYY", test2.NText);
Assert.AreEqual(count, DataUtil.CountRows("NullableCharacters"));
}
