public virtual void Test_Can_Do_Projection_With_Different_Field_Names()
{
TestJoinObjectSameFields o1 = new TestJoinObjectSameFields();
o1.SortOrder = 10;
dStore.InsertObject(o1);
TestObjectSameFields o2 = new TestObjectSameFields();
o2.SortOrder = 5;
o2.ForeignKey = o1.ID;
dStore.InsertObject(o2);
var data = from i in dStore.Query <TestObjectSameFields>()
join x in dStore.Query <TestJoinObjectSameFields>() on i.ForeignKey equals x.ID
select new
{
i.ID,
MySort = x.SortOrder,
SortOrder1 = i.SortOrder
};
Assert.IsTrue(data.Count() == 1);
Assert.IsTrue(data.First().MySort == 10);
Assert.IsTrue(data.First().SortOrder1 == 5);
}
public virtual void Test_Can_Do_Join_When_Two_Objects_Have_Same_Field()
{
TestJoinObjectSameFields o1 = new TestJoinObjectSameFields();
o1.SortOrder = 10;
dStore.InsertObject(o1);
TestObjectSameFields o2 = new TestObjectSameFields();
o2.SortOrder = 5;
o2.ForeignKey = o1.ID;
dStore.InsertObject(o2);
var data = from i in dStore.Query <TestObjectSameFields>()
join x in dStore.Query <TestJoinObjectSameFields>() on i.ForeignKey equals x.ID
select new
{
i.ID,
x.SortOrder,
SortOrder1 = i.SortOrder
};
Assert.IsTrue(data.Count() == 1);
Assert.IsTrue(data.First().SortOrder == 10);
Assert.IsTrue(data.First().SortOrder1 == 5);
}
public virtual void Test_Can_Map_Reuslt_Data_When_More_Than_One_Object_Requires_Same_Field_Name()
{
TestJoinObjectSameFields o1 = new TestJoinObjectSameFields();
o1.SortOrder = 10;
dStore.InsertObject(o1);
TestObjectSameFields o2 = new TestObjectSameFields();
o2.SortOrder = 5;
o2.ForeignKey = o1.ID;
dStore.InsertObject(o2);
var data = from i in dStore.Query <TestObjectSameFields>()
join x in dStore.Query <TestJoinObjectSameFields>() on i.ForeignKey equals x.ID
select new
{
i,
x
};
}
