public void MultipleTablesTest() { GXUser user = new GXUser() { Id = "Gurux" }; GXUserGroup userGroup = new GXUserGroup(); userGroup.Users.Add(user); GXSelectArgs arg = GXSelectArgs.Select <GXUserGroup>(s => s.Id, where => where.Removed == null); arg.Where.FilterBy(userGroup, false); arg.Joins.AddInnerJoin <GXUserGroup, GXUserGroupUser>(j => j.Id, j => j.UserGroupId); arg.Joins.AddInnerJoin <GXUserGroupUser, GXUser>(j => j.UserId, j => j.Id); string[] userIds = new string[] { "Gurux" }; arg.Where.And <GXUser>(where => where.Removed == null && userIds.Contains(where.Id)); Assert.AreEqual("Mikko", arg.ToString()); }
public void ExcludeTest() { GXUser user = new GXUser() { Id = "Default" }; GXUserGroup item = new GXUserGroup() { Name = "Default" }; item.Users.Add(user); GXInsertArgs insert = GXInsertArgs.Insert(item); insert.Exclude <GXUserGroup>(e => e.CreationTime); insert.Exclude <GXUserGroup>(e => e.Users); Assert.AreEqual("Mikko", insert.ToString()); }