public void GetChildCategoriesByParentId_ReturnsOnlyAssociatedCategories()
        {
            IDbProxyContext context = Mock.It<IDbProxyContext>();

            List<ItemCategory> categories = new List<ItemCategory> { _musicParent, _musicChild, _musicChild2, _musicGrandChild };
            context.Set<ItemCategory>().Returns(categories.AsQueryable());

            var itemCategoryRelationDAO = new ItemCategoryDAOImpl(context, Mock.It<IDbManager>(), Mock.It<ILogger>());
            IEnumerable<ItemCategoryCount> categoryCounts = itemCategoryRelationDAO.GetChildCategoriesByParentId(Guid.Parse(Id)).ToList();

            Assert.That(categoryCounts.Count(), Is.EqualTo(2));
            Assert.That(categoryCounts.Count(c => c.Name == MusicVideoCategory), Is.EqualTo(1));
            Assert.That(categoryCounts.Count(c => c.Name == MusicInstrumentCategory), Is.EqualTo(1));
        }
        public void TestQuery()
        {
            ItemCategoryDAO dao = new ItemCategoryDAOImpl(new DbProxyContext(), Mock.It<IDbManager>(), Mock.It<ILogger>());

            IEnumerable<ItemCategoryCount> categories = dao.GetChildCategoriesByParentId(Guid.Parse(Id));

            Assert.True(categories.Any());
        }