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