public static void Test_OneToManyInsert() { Configuration cfg = (new Configuration()).Configure().AddAssembly(typeof(TestCUBRIDBlobType).Assembly); Nation nation = new Nation { code = "ROM", name = "Romania", capital = "Bucharest", continent = "Europe", Athletes = new List<AthleteOneToMany>() }; AthleteOneToMany athleteOneToMany = new AthleteOneToMany { name = "Lucian Bute", gender = "M", nation_code = "ROM", athlete_event = "Boxing", }; ISessionFactory sessionFactory = cfg.BuildSessionFactory(); using (ISession session = sessionFactory.OpenSession()) { using (ITransaction tx = session.BeginTransaction(IsolationLevel.ReadUncommitted)) { nation.Athletes.Add(athleteOneToMany); session.Save(nation); tx.Commit(); } } using (ISession session = sessionFactory.OpenSession()) { IEnumerator<Nation> nations = session.Query<Nation>().Fetch(b => b.Athletes).GetEnumerator(); while (nations.MoveNext()) { if (nations.Current.code == "ROM") break; } List<object> nationValues = GetTableValues("nation", 216, new string[] { "code", "name", "capital", "continent" }); List<object> athleteValues = GetTableValues("athlete", 6678, new string[] { "nation_code", "gender", "name", "event" }); Debug.Assert(nations.Current.code == (string)nationValues[0]); Debug.Assert(nations.Current.name == (string)nationValues[1]); Debug.Assert(nations.Current.capital == (string)nationValues[2]); Debug.Assert(nations.Current.continent == (string)nationValues[3]); Debug.Assert(nations.Current.Athletes.Count == 1); Debug.Assert(nations.Current.Athletes[0].nation_code == (string)athleteValues[0]); Debug.Assert(nations.Current.Athletes[0].gender == (string)athleteValues[1]); Debug.Assert(nations.Current.Athletes[0].name == (string)athleteValues[2]); Debug.Assert(nations.Current.Athletes[0].athlete_event == (string)athleteValues[3]); } using (ISession session = sessionFactory.OpenSession()) { //Delete a inserted information using (var trans = session.BeginTransaction(IsolationLevel.ReadUncommitted)) { session.Delete(nation); trans.Commit(); } } }
public static void Test_OneToManyInsert() { Configuration cfg = (new Configuration()).Configure().AddAssembly(typeof(TestCUBRIDBlobType).Assembly); Nation nation = new Nation { code = "ROM", name = "Romania", capital = "Bucharest", continent = "Europe", Athletes = new List <AthleteOneToMany>() }; AthleteOneToMany athleteOneToMany = new AthleteOneToMany { name = "Lucian Bute", gender = "M", nation_code = "ROM", athlete_event = "Boxing", }; ISessionFactory sessionFactory = cfg.BuildSessionFactory(); using (ISession session = sessionFactory.OpenSession()) { using (ITransaction tx = session.BeginTransaction(IsolationLevel.ReadUncommitted)) { nation.Athletes.Add(athleteOneToMany); session.Save(nation); tx.Commit(); } } using (ISession session = sessionFactory.OpenSession()) { IEnumerator <Nation> nations = session.Query <Nation>().Fetch(b => b.Athletes).GetEnumerator(); while (nations.MoveNext()) { if (nations.Current.code == "ROM") { break; } } List <object> nationValues = GetTableValues("nation", 216, new string[] { "code", "name", "capital", "continent" }); List <object> athleteValues = GetTableValues("athlete", 6678, new string[] { "nation_code", "gender", "name", "event" }); Debug.Assert(nations.Current.code == (string)nationValues[0]); Debug.Assert(nations.Current.name == (string)nationValues[1]); Debug.Assert(nations.Current.capital == (string)nationValues[2]); Debug.Assert(nations.Current.continent == (string)nationValues[3]); Debug.Assert(nations.Current.Athletes.Count == 1); Debug.Assert(nations.Current.Athletes[0].nation_code == (string)athleteValues[0]); Debug.Assert(nations.Current.Athletes[0].gender == (string)athleteValues[1]); Debug.Assert(nations.Current.Athletes[0].name == (string)athleteValues[2]); Debug.Assert(nations.Current.Athletes[0].athlete_event == (string)athleteValues[3]); } using (ISession session = sessionFactory.OpenSession()) { //Delete a inserted information using (var trans = session.BeginTransaction(IsolationLevel.ReadUncommitted)) { session.Delete(nation); trans.Commit(); } } }
public static void Test_OneToManyDelete() { Configuration cfg = (new Configuration()).Configure().AddAssembly(typeof(TestCUBRIDBlobType).Assembly); ISessionFactory sessionFactory = cfg.BuildSessionFactory(); using (ISession session = sessionFactory.OpenSession()) { IEnumerator<Nation> nations = session.Query<Nation>().Fetch(b => b.Athletes).GetEnumerator(); int count = 0; while (nations.MoveNext()) { count++; } Debug.Assert(count == 215); } Nation nation = new Nation { code = "ROM", name = "Romania", capital = "Bucharest", continent = "Europe", Athletes = new List<AthleteOneToMany>() }; AthleteOneToMany athleteOneToMany = new AthleteOneToMany { name = "Lucian Bute", gender = "M", nation_code = "ROM", athlete_event = "Boxing", }; nation.Athletes.Add(athleteOneToMany); using (ISession session = sessionFactory.OpenSession()) { using (ITransaction tx = session.BeginTransaction(IsolationLevel.ReadUncommitted)) { session.Save(nation); tx.Commit(); } } using (ISession session = sessionFactory.OpenSession()) { IEnumerator<Nation> nations = session.Query<Nation>().Fetch(b => b.Athletes).GetEnumerator(); int count = 0; while (nations.MoveNext()) { count++; } Debug.Assert(count == 216); } using (ISession session = sessionFactory.OpenSession()) { //Delete a inserted information using (var trans = session.BeginTransaction(IsolationLevel.ReadUncommitted)) { session.Delete(nation); trans.Commit(); } } using (ISession session = sessionFactory.OpenSession()) { IEnumerator<Nation> nations = session.Query<Nation>().Fetch(b => b.Athletes).GetEnumerator(); int count = 0; while (nations.MoveNext()) { count++; } Debug.Assert(count == 215); } }
public static void Test_OneToManyDelete() { Configuration cfg = (new Configuration()).Configure().AddAssembly(typeof(TestCUBRIDBlobType).Assembly); ISessionFactory sessionFactory = cfg.BuildSessionFactory(); using (ISession session = sessionFactory.OpenSession()) { IEnumerator <Nation> nations = session.Query <Nation>().Fetch(b => b.Athletes).GetEnumerator(); int count = 0; while (nations.MoveNext()) { count++; } Debug.Assert(count == 215); } Nation nation = new Nation { code = "ROM", name = "Romania", capital = "Bucharest", continent = "Europe", Athletes = new List <AthleteOneToMany>() }; AthleteOneToMany athleteOneToMany = new AthleteOneToMany { name = "Lucian Bute", gender = "M", nation_code = "ROM", athlete_event = "Boxing", }; nation.Athletes.Add(athleteOneToMany); using (ISession session = sessionFactory.OpenSession()) { using (ITransaction tx = session.BeginTransaction(IsolationLevel.ReadUncommitted)) { session.Save(nation); tx.Commit(); } } using (ISession session = sessionFactory.OpenSession()) { IEnumerator <Nation> nations = session.Query <Nation>().Fetch(b => b.Athletes).GetEnumerator(); int count = 0; while (nations.MoveNext()) { count++; } Debug.Assert(count == 216); } using (ISession session = sessionFactory.OpenSession()) { //Delete a inserted information using (var trans = session.BeginTransaction(IsolationLevel.ReadUncommitted)) { session.Delete(nation); trans.Commit(); } } using (ISession session = sessionFactory.OpenSession()) { IEnumerator <Nation> nations = session.Query <Nation>().Fetch(b => b.Athletes).GetEnumerator(); int count = 0; while (nations.MoveNext()) { count++; } Debug.Assert(count == 215); } }