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 }; }