public void GetTest()
        {
            MemorySQLConnection <Category> connection = new MemorySQLConnection <Category>();
            var categoria = new CategoriesDAO(connection);
            var result    = categoria.Get();


            Assert.AreEqual(2, categoria.Get().Count());
            Assert.AreEqual(10, categoria.Get().First().Id);
        }
        public void DeleteTest()
        {
            MemorySQLConnection <Category> connection = new MemorySQLConnection <Category>();
            var categoria = new CategoriesDAO(connection);
            var result    = categoria.Delete(11);

            Assert.IsTrue(result);
            Assert.AreEqual(1, categoria.Get().Count());
            Assert.AreNotEqual(11, categoria.Get().First().Id);
        }
        public void UpdateTest()
        {
            MemorySQLConnection <Category> connection = new MemorySQLConnection <Category>();
            var categoria = new CategoriesDAO(connection);
            var cat       = new Category()
            {
                Id          = 10,
                Description = "categoria com id 2"
            };
            var result = categoria.Update(cat);


            Assert.AreEqual(2, categoria.Get().Count());
            Assert.AreEqual("categoria com id 2", categoria.Get().First(x => x.Id == 10).Description);
        }
        public void InsertTest()
        {
            MemorySQLConnection <Category> connection = new MemorySQLConnection <Category>();
            var categoria = new CategoriesDAO(connection);
            var cat       = new Category()
            {
                Id          = 2,
                Description = "categoria com id 2"
            };
            var result = categoria.Insert(cat);


            Assert.AreEqual(3, categoria.Get().Count());
            Assert.IsTrue(categoria.Get().Any(x => x.Id == 2));
            Assert.AreEqual(cat, categoria.Get().First(x => x.Id == 2));
            Assert.AreEqual(cat, result);
        }