public void NonLazyBidirectional() { DomainModel.Single sin = new DomainModel.Single(); sin.Id = "asfdfds"; sin.String = "adsa asdfasd"; Several sev = new Several(); sev.Id = "asdfasdfasd"; sev.String = "asd ddd"; sin.Several.Add(sev); sev.Single = sin; using( ISession s = OpenSession() ) using( ITransaction t = s.BeginTransaction() ) { s.Save(sin); t.Commit(); } using( ISession s = OpenSession() ) using( ITransaction t = s.BeginTransaction() ) { sin = (DomainModel.Single)s.Load( typeof(DomainModel.Single), sin ); t.Commit(); } using( ISession s = OpenSession() ) using( ITransaction t = s.BeginTransaction() ) { sev = (Several)s.Load( typeof(Several), sev ); t.Commit(); } using( ISession s = OpenSession() ) using( ITransaction t = s.BeginTransaction() ) { s.Find("from s in class Several"); t.Commit(); } using( ISession s = OpenSession() ) using( ITransaction t = s.BeginTransaction() ) { s.Find("from s in class Single"); t.Commit(); } using( ISession s = OpenSession() ) using( ITransaction t = s.BeginTransaction() ) { s.Delete( "from Single" ); t.Commit(); } }
public void EmbeddedCompositeProperties() { ISession session = OpenSession(); DomainModel.Single s = new DomainModel.Single(); s.Id = "my id"; s.String = "string 1"; session.Save(s); session.Flush(); session.Clear(); IQuery query = session.CreateSQLQuery("select {sing.*} from Single {sing}", "sing", typeof( DomainModel.Single )); IList list = query.List(); Assert.IsTrue(list.Count==1); session.Clear(); query = session.CreateSQLQuery("select {sing.*} from Single {sing} where sing.Id = ?", "sing", typeof( DomainModel.Single )); query.SetString(0, "my id"); list = query.List(); Assert.IsTrue(list.Count==1); session.Clear(); query = session.CreateSQLQuery("select s.id as {sing.Id}, s.string_ as {sing.String}, s.prop as {sing.Prop} from Single s where s.Id = ?", "sing", typeof( DomainModel.Single )); query.SetString(0, "my id"); list = query.List(); Assert.IsTrue(list.Count==1); session.Clear(); query = session.CreateSQLQuery("select s.id as {sing.Id}, s.string_ as {sing.String}, s.prop as {sing.Prop} from Single s where s.Id = ?", "sing", typeof( DomainModel.Single )); query.SetString(0, "my id"); list = query.List(); Assert.IsTrue(list.Count==1); session.Delete( list[0] ); session.Flush(); session.Close(); }
public void PolymorphicCriteria() { ISession s = OpenSession(); Category f = new Category(); DomainModel.Single b = new DomainModel.Single(); b.Id = "asdfa"; b.String = "asdfasdf"; s.Save( f ); s.Save( b ); IList list = s.CreateCriteria( typeof( object )).List(); Assert.AreEqual( 2, list.Count ); Assert.IsTrue( list.Contains( f ) ); Assert.IsTrue( list.Contains( b ) ); s.Delete( f ); s.Delete( b ); s.Flush(); s.Close(); }