public void SelectMaxValues()
{
int count = DataUtil.CountRows("Binary");
ObjectTransaction transaction = manager.BeginTransaction();
BinaryTestObject test = transaction.Select(typeof(BinaryTestObject), MaxValues) as BinaryTestObject;
Assert.AreEqual(new Guid(MaxValues), test.Id);
Assert.AreEqual(8, test.Binary.Length);
foreach (byte b in test.Binary)
{
Assert.AreEqual(Byte.MaxValue, b);
}
Assert.AreEqual(16, test.VarBinary.Length);
foreach (byte b in test.VarBinary)
{
Assert.AreEqual(Byte.MaxValue, b);
}
Assert.AreEqual(32, test.Image.Length);
foreach (byte b in test.Image)
{
Assert.AreEqual(Byte.MaxValue, b);
}
Assert.AreEqual(count, DataUtil.CountRows("Binary"));
}
public void CreateCircularReference()
{
int pA = DataUtil.CountRows("ParentA");
int pB = DataUtil.CountRows("ParentB");
int cA = DataUtil.CountRows("ChildA");
ObjectTransaction transaction = manager.BeginTransaction();
ParentBTestObject parentB = transaction.Create(typeof(ParentBTestObject)) as ParentBTestObject;
parentB.ObjData = "B";
ParentATestObject parentA = transaction.Create(typeof(ParentATestObject)) as ParentATestObject;
parentA.ObjData = "A";
parentA.ParentB = parentB;
ChildATestObject childA = transaction.Create(typeof(ChildATestObject)) as ChildATestObject;
childA.ParentA = parentA;
childA.ParentB = parentB;
transaction.Commit();
Assert.AreEqual(pA + 1, DataUtil.CountRows("ParentA"));
Assert.AreEqual(pB + 1, DataUtil.CountRows("ParentB"));
Assert.AreEqual(cA + 1, DataUtil.CountRows("ChildA"));
}
public void Or()
{
ObjectTransaction transaction = manager.BeginTransaction();
Query query = new Query(new ConditionGroup(ConditionGroupType.Or, new Condition("Boolean", Expression.Equal, true), new Condition("Boolean", Expression.Equal, false)));
ServerObjectCollection objects = transaction.Select(typeof(SimpleConstraintTestObject), query);
Assert.AreEqual(4, objects.Count);
}
public void EmptyConditions()
{
ObjectTransaction transaction = manager.BeginTransaction();
Query query = new Query(new SetCondition("ChildObjects"));
ServerObjectCollection objects = transaction.Select(typeof(IdentityParentTestObject), query);
Assert.AreEqual(1, objects.Count);
}
public void SelectValentines()
{
ObjectTransaction transaction = manager.BeginTransaction();
Occasion valentines = transaction.Select(typeof(Occasion), 11) as Occasion;
Query query = new Query(new SetCondition("OccasionMaps", new Condition("Occasion", Expression.Equal, valentines.Id)));
ServerObjectCollection recipes = transaction.Select(typeof(Recipe), query);
Assert.AreEqual(23, recipes.Count);
}
public void SelectCakes()
{
ObjectTransaction transaction = manager.BeginTransaction();
Query query = new Query(new Condition("Category", Expression.Equal, 1));
ServerObjectCollection recipes = transaction.Select(typeof(Recipe), query);
Recipe recipe = recipes[0] as Recipe;
Assert.AreEqual(454, recipe.Id);
Assert.AreEqual(84, recipes.Count);
}
public void DoubleCommit()
{
ObjectTransaction transaction1 = manager.BeginTransaction();
SimpleConstraintTestObject obj1 = transaction1.Select(typeof(SimpleConstraintTestObject), 1) as SimpleConstraintTestObject;
obj1.Varchar = "XXX";
transaction1.Commit();
obj1.Varchar = "YYY";
transaction1.Commit();
ObjectTransaction transaction2 = manager.BeginTransaction();
SimpleConstraintTestObject obj2 = transaction2.Select(typeof(SimpleConstraintTestObject), 1) as SimpleConstraintTestObject;
Assert.AreEqual("YYY", obj2.Varchar);
}
public void SelectMaxValues()
{
int count = DataUtil.CountRows("Integers");
ObjectTransaction transaction = manager.BeginTransaction();
IntegerTestObject test = transaction.Select(typeof(IntegerTestObject), MaxValues) as IntegerTestObject;
Assert.AreEqual(new Guid(MaxValues), test.Id);
Assert.AreEqual(true, test.Boolean);
Assert.AreEqual(Byte.MaxValue, test.TinyInt);
Assert.AreEqual(Int16.MaxValue, test.SmallInt);
Assert.AreEqual(Int32.MaxValue, test.Int);
Assert.AreEqual(Int64.MaxValue, test.BigInt);
Assert.AreEqual(count, DataUtil.CountRows("Integers"));
}
public void SelectMaxValues()
{
int count = DataUtil.CountRows("DateTimes");
ObjectTransaction transaction = manager.BeginTransaction();
DateTimeTestObject test = transaction.Select(typeof(DateTimeTestObject), MaxValues) as DateTimeTestObject;
Assert.AreEqual(new Guid(MaxValues), test.Id);
Assert.AreEqual(new DateTime(9999, 12, 31), test.Date);
Assert.AreEqual(new DateTime(2079, 6, 6), test.SmallDate);
Assert.AreEqual(count, DataUtil.CountRows("DateTimes"));
}
public void SelectMaxValues()
{
int count = DataUtil.CountRows("FloatingPointNumbers");
ObjectTransaction transaction = manager.BeginTransaction();
FloatingPointNumberTestObject test = transaction.Select(typeof(FloatingPointNumberTestObject), MaxValues) as FloatingPointNumberTestObject;
Assert.AreEqual(new Guid(MaxValues), test.Id);
Assert.AreEqual(Decimal.MaxValue, test.Decimal);
Assert.AreEqual(Decimal.MaxValue, test.Numeric);
Assert.AreEqual(Double.MaxValue, test.Float);
Assert.AreEqual(Single.MaxValue, test.Real);
Assert.AreEqual(922337203685477.5807m, test.Money);
Assert.AreEqual(214748.3647m, test.SmallMoney);
Assert.AreEqual(count, DataUtil.CountRows("FloatingPointNumbers"));
}
public void Select()
{
int count = DataUtil.CountRows("DefinedKeys");
ObjectTransaction transaction = manager.BeginTransaction();
DefinedKeyTestObject test = transaction.Select(typeof(DefinedKeyTestObject), "defined1") as DefinedKeyTestObject;
Assert.AreEqual("defined1", test.Id);
Assert.AreEqual(1, test.ObjData);
Assert.AreEqual(count, DataUtil.CountRows("DefinedKeys"));
}
public void Select()
{
int count = DataUtil.CountRows("IdentityKeys");
ObjectTransaction transaction = manager.BeginTransaction();
IdentityKeyTestObject test = transaction.Select(typeof(IdentityKeyTestObject), 1) as IdentityKeyTestObject;
Assert.AreEqual(1, test.Id);
Assert.AreEqual("data1", test.ObjData);
Assert.AreEqual(count, DataUtil.CountRows("IdentityKeys"));
}
public void SingleParentCondition()
{
ObjectTransaction transaction = manager.BeginTransaction();
Query query = new Query(new Condition("Parent.ObjData", Expression.Equal, "A"));
ServerObjectCollection objects = transaction.Select(typeof(IdentityChildTestObject), query);
Assert.AreEqual(2, objects.Count);
IdentityChildTestObject obj1 = objects[0] as IdentityChildTestObject;
Assert.AreEqual(1, obj1.Id);
Assert.AreEqual("A", obj1.ObjData);
Assert.AreEqual(3, obj1.Parent.Id);
Assert.AreEqual("A", obj1.Parent.ObjData);
Assert.AreEqual(2, obj1.Parent.ChildObjects.Count);
IdentityChildTestObject obj2 = objects[1] as IdentityChildTestObject;
Assert.AreEqual(2, obj2.Id);
Assert.AreEqual("B", obj2.ObjData);
Assert.AreEqual(3, obj2.Parent.Id);
Assert.AreEqual("A", obj2.Parent.ObjData);
Assert.AreEqual(2, obj2.Parent.ChildObjects.Count);
}
public void SelectParent()
{
int count = DataUtil.CountRows("NullParents");
ObjectTransaction transaction = manager.BeginTransaction();
NullParentTestObject obj = transaction.Select(typeof(NullParentTestObject), 1) as NullParentTestObject;
Assert.AreEqual(1, obj.Id);
Assert.AreEqual(1, obj.Value);
Assert.AreEqual(2, obj.ChildObjects.Count);
Assert.AreEqual(count, DataUtil.CountRows("NullParents"));
}
public void SelectRandomValues()
{
int count = DataUtil.CountRows("Characters");
ObjectTransaction transaction = manager.BeginTransaction();
CharacterTestObject test = transaction.Select(typeof(CharacterTestObject), RandomValues) as CharacterTestObject;
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("Characters"));
}
public void Select()
{
int count = DataUtil.CountRows("GuidKeys");
Guid id = new Guid("{DAB20E73-806B-42F6-9A59-8240487848A4}");
ObjectTransaction transaction = manager.BeginTransaction();
GuidKeyTestObject test = transaction.Select(typeof(GuidKeyTestObject), id) as GuidKeyTestObject;
Assert.AreEqual(id, test.Id);
Assert.AreEqual(1, test.ObjData);
Assert.AreEqual(count, DataUtil.CountRows("GuidKeys"));
}
static void Main(string[] args)
{
ObjectManager sql = new ObjectManager(ServerType.SqlServer, @"Integrated Security=SSPI; Persist Security Info=False; Initial Catalog=Chelsea; Data Source=Azrael;");
ObjectTransaction transaction = sql.BeginTransaction();
Query query = new Query(
new Condition("Author.Id", Expression.IsNotNull)
);
query.Order = "Author.firstname";
ServerObjectCollection recipes = transaction.Select(typeof(Recipe), query);
foreach (Recipe recipe in recipes)
{
Console.WriteLine("{0} - {1}", recipe.Author.Firstname, recipe.Name);
}
}
public void SelectParentWithoutChildren()
{
int count = DataUtil.CountRows("GuidParents");
ObjectTransaction transaction = manager.BeginTransaction();
CascadeGuidParentTestObject parent = transaction.Select(typeof(CascadeGuidParentTestObject), "{F9643D1E-9FAC-4C01-B535-D2B0D2F582E7}") as CascadeGuidParentTestObject;
Assert.AreEqual(new Guid("{F9643D1E-9FAC-4C01-B535-D2B0D2F582E7}"), parent.Id);
Assert.AreEqual("Y", parent.ObjData);
Assert.AreEqual(0, parent.ChildObjects.Count);
Assert.AreEqual(count, DataUtil.CountRows("GuidParents"));
}
public void SelectAll()
{
ObjectTransaction transaction = manager.BeginTransaction();
Query query = new Query();
ServerObjectCollection objects = transaction.Select(typeof(SimpleConstraintTestObject), query);
Assert.AreEqual(4, objects.Count);
}
public void SelectParentWithoutChildren()
{
int count = DataUtil.CountRows("DefinedParents");
ObjectTransaction transaction = manager.BeginTransaction();
DefinedParentTestObject parent = transaction.Select(typeof(DefinedParentTestObject), "Key2") as DefinedParentTestObject;
Assert.AreEqual("Key2", parent.Id);
Assert.AreEqual("Data2", parent.ObjData);
Assert.AreEqual(0, parent.ChildObjects.Count);
Assert.AreEqual(count, DataUtil.CountRows("DefinedParents"));
}
public void SelectParentWithoutChildren()
{
int count = DataUtil.CountRows("IdentityParents");
ObjectTransaction transaction = manager.BeginTransaction();
IdentityParentTestObject parent = transaction.Select(typeof(IdentityParentTestObject), 4) as IdentityParentTestObject;
Assert.AreEqual(4, parent.Id);
Assert.AreEqual("B", parent.ObjData);
Assert.AreEqual(0, parent.ChildObjects.Count);
Assert.AreEqual(count, DataUtil.CountRows("IdentityParents"));
}
