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