protected override void OnSetUp() { base.OnSetUp(); using (ISession session = this.OpenSession()) { ArticleGroupItem agrp_1 = new ArticleGroupItem(); agrp_1.Name = "Article group 1"; session.Save(agrp_1); ArticleGroupItem agrp_2 = new ArticleGroupItem(); agrp_2.Name = "Article group 2"; session.Save(agrp_2); session.Flush(); ArticleItem article_1 = new ArticleItem(); article_1.Articlegroup = agrp_1; article_1.Name = "Article 1 grp 1"; article_1.IsFavorite = 0; session.Save("Article", article_1); ArticleItem article_2 = new ArticleItem(); article_2.Articlegroup = agrp_1; article_2.Name = "Article 2 grp 1"; article_2.IsFavorite = 1; session.Save("Article", article_2); ArticleItem article_3 = new ArticleItem(); article_3.Articlegroup = agrp_2; article_3.Name = "Article 1 grp 2"; article_3.IsFavorite = 0; session.Save("Article", article_3); session.Flush(); } }
public void Can_GetListOfArticles() { string HQL; IList <ArticleItem> result; //add new using (ISession session = this.OpenSession()) { ArticleItem item = new ArticleItem(); item.Name = "Test article"; item.IsFavorite = 0; session.Save("Article", item); session.Flush(); } //here first problem, no entities are returned <======== HQL = "from Article"; using (ISession session = this.OpenSession()) { result = session.CreateQuery(HQL).List <ArticleItem>(); } Assert.That(result.Count, Is.GreaterThan(0)); }
public void Can_GetListOfArticles() { string HQL; IList<ArticleItem> result; //add new using (ISession session = this.OpenSession()) { ArticleItem item = new ArticleItem(); item.Name = "Test article"; item.IsFavorite = 0; session.Save("Article", item); session.Flush(); } //here first problem, no entities are returned <======== HQL = "from Article"; using (ISession session = this.OpenSession()) { result = session.CreateQuery(HQL).List<ArticleItem>(); } result.Count.Should().Be.GreaterThan(0); }