public void GetAll_WhenTwoItemsExists_ReturnsBothItems()
        {
            var item1 = new IdentityItemForGetQueries { SortOrder = 1 };
            var item2 = new IdentityItemForGetQueries { SortOrder = 2 };

            using (var unitOfWork = Database.CreateUnitOfWork())
            {
                unitOfWork.Insert(item1);
                unitOfWork.Insert(item2);
                unitOfWork.Commit();
            }

            IEnumerable<IdentityItemForGetQueries> refetched;
            using (var unitOfWork = Database.CreateUnitOfWork())
            {
                refetched = unitOfWork.GetAll<IdentityItemForGetQueries>().ToArray();
            }

            Assert.AreEqual(2, refetched.Count());
        }
        public void GetByIdentityId_WhenTwoItemsExistsAndTheSecondIsQueriedFor_ReturnsTheCorrectItem()
        {
            var item1 = new IdentityItemForGetQueries { SortOrder = 1 };
            var item2 = new IdentityItemForGetQueries { SortOrder = 2 };

            using (var unitOfWork = Database.CreateUnitOfWork())
            {
                unitOfWork.Insert(item1);
                unitOfWork.Insert(item2);
                unitOfWork.Commit();
            }

            IdentityItemForGetQueries itemRefetched;
            using (var unitOfWork = Database.CreateUnitOfWork())
            {
                itemRefetched = unitOfWork.GetById<IdentityItemForGetQueries>(item2.Id);
            }

            Assert.AreEqual(item2.SortOrder, itemRefetched.SortOrder);
        }
        public void GetByIdentityIdAsJson_WhenTwoItemsExistsAndTheSecondIsQueriedFor_ReturnsTheCorrectItemJson()
        {
            var item1 = new IdentityItemForGetQueries { SortOrder = 1 };
            var item2 = new IdentityItemForGetQueries { SortOrder = 2 };

            using (var unitOfWork = Database.CreateUnitOfWork())
            {
                unitOfWork.Insert(item1);
                unitOfWork.Insert(item2);
                unitOfWork.Commit();
            }

            string itemJsonRefetched;
            using (var unitOfWork = Database.CreateUnitOfWork())
            {
                itemJsonRefetched = unitOfWork.GetByIdAsJson<IdentityItemForGetQueries>(item2.Id);
            }

            Assert.AreEqual("{\"Id\":2,\"SortOrder\":2}", itemJsonRefetched);
        }