public void LoadByIDFailure() { UserGroup ug1 = new UserGroup(); ug1.Name = "Group1"; User ui1 = new User("User1"); ISession s = OpenSession(); s.BeginTransaction(); object gid1 = s.Save(ug1); object uid1 = s.Save(ui1); s.Transaction.Commit(); s.Close(); s = OpenSession(); s.BeginTransaction(); //Load user with USER NAME: ICriteria criteria1 = s.CreateCriteria(typeof(User)); criteria1.Add(Expression.Eq("Name", "User1")); Assert.AreEqual(1, criteria1.List().Count); s.Transaction.Commit(); s.Close(); s = OpenSession(); s.BeginTransaction(); //Load group with USER NAME: ICriteria criteria2 = s.CreateCriteria(typeof(UserGroup)); criteria2.Add(Expression.Eq("Name", "User1")); Assert.AreEqual(0, criteria2.List().Count); s.Transaction.Commit(); s.Close(); s = OpenSession(); s.BeginTransaction(); //Load group with GROUP NAME ICriteria criteria3 = s.CreateCriteria(typeof(UserGroup)); criteria3.Add(Expression.Eq("Name", "Group1")); Assert.AreEqual(1, criteria3.List().Count); s.Transaction.Commit(); s.Close(); s = OpenSession(); s.BeginTransaction(); //Load user with GROUP NAME ICriteria criteria4 = s.CreateCriteria(typeof(User)); criteria4.Add(Expression.Eq("Name", "Group1")); Assert.AreEqual(0, criteria4.List().Count); s.Transaction.Commit(); s.Close(); s = OpenSession(); s.BeginTransaction(); //Load group with USER IDENTITY ug1 = (UserGroup) s.Get(typeof(UserGroup), uid1); Assert.IsNull(ug1); s.Transaction.Commit(); s.Close(); s = OpenSession(); s.BeginTransaction(); ui1 = (User) s.Get(typeof(User), gid1); Assert.IsNull(ui1); s.Transaction.Commit(); s.Close(); s = OpenSession(); s.BeginTransaction(); Party p = (Party) s.Get(typeof(Party), uid1); Assert.IsTrue(p is User); p = (Party) s.Get(typeof(Party), gid1); Assert.IsTrue(p is UserGroup); s.Transaction.Commit(); s.Close(); s = OpenSession(); s.BeginTransaction(); s.Delete("from Party"); s.Transaction.Commit(); s.Close(); }
public async Task LoadByIDFailureAsync() { UserGroup ug1 = new UserGroup(); ug1.Name = "Group1"; User ui1 = new User("User1"); ISession s = OpenSession(); s.BeginTransaction(); object gid1 = await(s.SaveAsync(ug1)); object uid1 = await(s.SaveAsync(ui1)); await(s.Transaction.CommitAsync()); s.Close(); s = OpenSession(); s.BeginTransaction(); //Load user with USER NAME: ICriteria criteria1 = s.CreateCriteria(typeof(User)); criteria1.Add(Expression.Eq("Name", "User1")); Assert.AreEqual(1, (await(criteria1.ListAsync())).Count); await(s.Transaction.CommitAsync()); s.Close(); s = OpenSession(); s.BeginTransaction(); //Load group with USER NAME: ICriteria criteria2 = s.CreateCriteria(typeof(UserGroup)); criteria2.Add(Expression.Eq("Name", "User1")); Assert.AreEqual(0, (await(criteria2.ListAsync())).Count); await(s.Transaction.CommitAsync()); s.Close(); s = OpenSession(); s.BeginTransaction(); //Load group with GROUP NAME ICriteria criteria3 = s.CreateCriteria(typeof(UserGroup)); criteria3.Add(Expression.Eq("Name", "Group1")); Assert.AreEqual(1, (await(criteria3.ListAsync())).Count); await(s.Transaction.CommitAsync()); s.Close(); s = OpenSession(); s.BeginTransaction(); //Load user with GROUP NAME ICriteria criteria4 = s.CreateCriteria(typeof(User)); criteria4.Add(Expression.Eq("Name", "Group1")); Assert.AreEqual(0, (await(criteria4.ListAsync())).Count); await(s.Transaction.CommitAsync()); s.Close(); s = OpenSession(); s.BeginTransaction(); //Load group with USER IDENTITY ug1 = (UserGroup)await(s.GetAsync(typeof(UserGroup), uid1)); Assert.IsNull(ug1); await(s.Transaction.CommitAsync()); s.Close(); s = OpenSession(); s.BeginTransaction(); ui1 = (User)await(s.GetAsync(typeof(User), gid1)); Assert.IsNull(ui1); await(s.Transaction.CommitAsync()); s.Close(); s = OpenSession(); s.BeginTransaction(); Party p = (Party)await(s.GetAsync(typeof(Party), uid1)); Assert.IsTrue(p is User); p = (Party)await(s.GetAsync(typeof(Party), gid1)); Assert.IsTrue(p is UserGroup); await(s.Transaction.CommitAsync()); s.Close(); s = OpenSession(); s.BeginTransaction(); await(s.DeleteAsync("from Party")); await(s.Transaction.CommitAsync()); s.Close(); }
public void List() { using (ISession s = OpenSession()) using (ITransaction t = s.BeginTransaction()) { User user = new User(); user.Name = "user"; UserGroup group = new UserGroup(); group.Name = "user"; group.Users.Add(user); s.Save(group); s.Save(user); s.CreateCriteria(typeof(Party)).List(); s.Delete("from Party"); t.Commit(); } }
public void LoadByIDFailure() { UserGroup ug1 = new UserGroup(); ug1.Name = "Group1"; User ui1 = new User("User1"); object gid1, uid1; using (var s = OpenSession()) using (var t = s.BeginTransaction()) { gid1 = s.Save(ug1); uid1 = s.Save(ui1); t.Commit(); s.Close(); } using (var s = OpenSession()) using (var t = s.BeginTransaction()) { //Load user with USER NAME: ICriteria criteria1 = s.CreateCriteria(typeof(User)); criteria1.Add(Expression.Eq("Name", "User1")); Assert.AreEqual(1, criteria1.List().Count); t.Commit(); s.Close(); } using (var s = OpenSession()) using (var t = s.BeginTransaction()) { //Load group with USER NAME: ICriteria criteria2 = s.CreateCriteria(typeof(UserGroup)); criteria2.Add(Expression.Eq("Name", "User1")); Assert.AreEqual(0, criteria2.List().Count); t.Commit(); s.Close(); } using (var s = OpenSession()) using (var t = s.BeginTransaction()) { //Load group with GROUP NAME ICriteria criteria3 = s.CreateCriteria(typeof(UserGroup)); criteria3.Add(Expression.Eq("Name", "Group1")); Assert.AreEqual(1, criteria3.List().Count); t.Commit(); s.Close(); } using (var s = OpenSession()) using (var t = s.BeginTransaction()) { //Load user with GROUP NAME ICriteria criteria4 = s.CreateCriteria(typeof(User)); criteria4.Add(Expression.Eq("Name", "Group1")); Assert.AreEqual(0, criteria4.List().Count); t.Commit(); s.Close(); } using (var s = OpenSession()) using (var t = s.BeginTransaction()) { //Load group with USER IDENTITY ug1 = (UserGroup)s.Get(typeof(UserGroup), uid1); Assert.IsNull(ug1); t.Commit(); s.Close(); } using (var s = OpenSession()) using (var t = s.BeginTransaction()) { ui1 = (User)s.Get(typeof(User), gid1); Assert.IsNull(ui1); t.Commit(); s.Close(); } using (var s = OpenSession()) using (var t = s.BeginTransaction()) { Party p = (Party)s.Get(typeof(Party), uid1); Assert.IsTrue(p is User); p = (Party)s.Get(typeof(Party), gid1); Assert.IsTrue(p is UserGroup); t.Commit(); s.Close(); } using (var s = OpenSession()) using (var t = s.BeginTransaction()) { s.Delete("from Party"); t.Commit(); s.Close(); } }