public void NPocoRepository_Update_Updates_Item_With_Correct_ID() { //Arrange var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(TestConstants.NPOCO_RecordCount); var repository = new NPocoRepository <Dog>(_nPocoUnitOfWork, mockCache.Object); var dog = new Dog { ID = TestConstants.NPOCO_UpdateDogId, Age = TestConstants.NPOCO_UpdateDogAge, Name = TestConstants.NPOCO_UpdateDogName }; //Act repository.Update(dog); //Assert DataTable table = DataUtil.GetTable(TestConstants.NPOCO_DatabaseName, TestConstants.NPOCO_TableName); foreach (DataRow row in table.Rows) { if ((int)row["ID"] == TestConstants.NPOCO_UpdateDogId) { Assert.AreEqual(TestConstants.NPOCO_UpdateDogAge, row["Age"]); Assert.AreEqual(TestConstants.NPOCO_UpdateDogName, row["Name"]); } } }
public void NPocoRepository_Delete_Does_Nothing_With_Invalid_ID() { //Arrange var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(TestConstants.NPOCO_RecordCount); var repository = new NPocoRepository <Dog>(_nPocoUnitOfWork, mockCache.Object); var dog = new Dog { ID = TestConstants.NPOCO_InvalidDogId, Age = TestConstants.NPOCO_DeleteDogAge, Name = TestConstants.NPOCO_DeleteDogName }; //Act repository.Delete(dog); //Assert //Assert int actualCount = DataUtil.GetRecordCount(TestConstants.NPOCO_DatabaseName, TestConstants.NPOCO_TableName); Assert.AreEqual(TestConstants.NPOCO_RecordCount, actualCount); }
public void NPocoRepository_GetAll_Returns_All_Rows(int count) { //Arrange var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(count); var repository = new NPocoRepository <Dog>(_nPocoUnitOfWork, mockCache.Object); //Act IEnumerable <Dog> dogs = repository.GetAll(); //Assert Assert.AreEqual(count, dogs.Count()); }
public void NPocoRepository_GetById_Returns_Null_If_InValid_Id() { //Arrange var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(5); var repository = new NPocoRepository <Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dog = repository.GetById(TestConstants.NPOCO_InvalidDogId); //Assert Assert.IsNull(dog); }
public void NPocoRepository_GetPage_Returns_Page_Of_Rows(int pageIndex, int pageSize) { //Arrange var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(TestConstants.PAGE_TotalCount); var repository = new NPocoRepository <Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dogs = repository.GetPage(pageIndex, pageSize); //Assert Assert.AreEqual(pageSize, dogs.PageSize); }
public void NPocoRepository_Find_Returns_Correct_Rows(int count, string sqlCondition, object arg) { //Arrange var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(TestConstants.PETAPOCO_RecordCount); var repository = new NPocoRepository <Dog>(_nPocoUnitOfWork, mockCache.Object); //Act IEnumerable <Dog> dogs = repository.Find(sqlCondition, arg); //Assert Assert.AreEqual(count, dogs.Count()); }
public void NPocoRepository_Find_Overload_Returns_Correct_Rows() { //Arrange var count = 4; var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(TestConstants.PETAPOCO_RecordCount); var repository = new NPocoRepository <Dog>(_nPocoUnitOfWork, mockCache.Object); //Act IEnumerable <Dog> dogs = repository.Find((d) => d.Age <= 5); //Assert Assert.AreEqual(count, dogs.Count()); }
public void NPocoRepository_GetById_Returns_Model_With_Correct_Properties() { //Arrange var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(5); var repository = new NPocoRepository <Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dog = repository.GetById(TestConstants.NPOCO_ValidDogId); //Assert Assert.AreEqual(TestConstants.NPOCO_ValidDogAge, dog.Age); Assert.AreEqual(TestConstants.NPOCO_ValidDogName, dog.Name); }
public void NPocoRepository_GetByProperty_Returns_List_Of_Models_If_Valid_Property(string dogName, int count) { //Arrange var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(5); var repository = new NPocoRepository <Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dogs = repository.GetByProperty("Name", dogName); //Assert Assert.IsInstanceOf <IEnumerable <Dog> >(dogs); Assert.AreEqual(count, dogs.Count()); }
public void NPocoRepository_GetByProperty_Returns_Instance_Of_Model_If_Valid_Property() { //Arrange var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(5); var dogName = _dogNames[2]; var repository = new NPocoRepository <Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dog = repository.GetByProperty("Name", dogName).FirstOrDefault(); //Assert Assert.IsInstanceOf <Dog>(dog); }
public void NPocoRepository_GetByProperty_Returns_Empty_List_If_InValid_Proeprty() { //Arrange var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(5); const string dogName = "Invalid"; var repository = new NPocoRepository <Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dogs = repository.GetByProperty("Name", dogName); //Assert Assert.IsInstanceOf <IEnumerable <Dog> >(dogs); Assert.AreEqual(0, dogs.Count()); }
public void NPocoRepository_GetAll_Returns_List_Of_Models() { //Arrange var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(5); var repository = new NPocoRepository <Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dogs = repository.GetAll().ToList(); //Assert for (int i = 0; i < dogs.Count(); i++) { Assert.IsInstanceOf <Dog>(dogs[i]); } }
public void NPocoRepository_GetByProperty_Returns_Models_With_Correct_Properties(string dogName) { //Arrange var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(5); var repository = new NPocoRepository <Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dogs = repository.GetByProperty("Name", dogName); //Assert foreach (Dog dog in dogs) { Assert.AreEqual(dogName, dog.Name); } }
public void NPocoRepository_GetPage_Returns_List_Of_Models() { //Arrange var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(TestConstants.PAGE_TotalCount); var repository = new NPocoRepository <Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dogs = repository.GetPage(TestConstants.PAGE_First, TestConstants.PAGE_RecordCount); //Assert for (int i = 0; i < dogs.Count(); i++) { Assert.IsInstanceOf <Dog>(dogs[i]); } }
public void NPocoRepository_GetPage_Returns_Models_With_Correct_Properties() { //Arrange var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(TestConstants.PAGE_TotalCount); var repository = new NPocoRepository <Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dogs = repository.GetPage(TestConstants.PAGE_First, TestConstants.PAGE_RecordCount); //Assert var dog = dogs.First(); Assert.AreEqual(_dogAges[0], dog.Age.ToString()); Assert.AreEqual(_dogNames[0], dog.Name); }
public void NPocoRepository_Add_Inserts_Item_Into_DataBase() { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(TestConstants.NPOCO_RecordCount); var repository = new NPocoRepository<Dog>(_nPocoUnitOfWork, mockCache.Object); var dog = new Dog { Age = TestConstants.NPOCO_InsertDogAge, Name = TestConstants.NPOCO_InsertDogName }; //Act repository.Add(dog); //Assert int actualCount = DataUtil.GetRecordCount(TestConstants.NPOCO_DatabaseName, TestConstants.NPOCO_TableName); Assert.AreEqual(TestConstants.NPOCO_RecordCount + 1, actualCount); }
public void NPocoRepository_Add_Inserts_Item_Into_DataBase() { //Arrange var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(TestConstants.NPOCO_RecordCount); var repository = new NPocoRepository <Dog>(_nPocoUnitOfWork, mockCache.Object); var dog = new Dog { Age = TestConstants.NPOCO_InsertDogAge, Name = TestConstants.NPOCO_InsertDogName }; //Act repository.Add(dog); //Assert int actualCount = DataUtil.GetRecordCount(TestConstants.NPOCO_DatabaseName, TestConstants.NPOCO_TableName); Assert.AreEqual(TestConstants.NPOCO_RecordCount + 1, actualCount); }
public void NPocoRepository_Add_Inserts_Item_Into_DataBase_With_Correct_ColumnValues() { //Arrange var mockCache = new Mock <ICacheProvider>(); SetUpDatabase(TestConstants.NPOCO_RecordCount); var repository = new NPocoRepository <Dog>(_nPocoUnitOfWork, mockCache.Object); var dog = new Dog { Age = TestConstants.NPOCO_InsertDogAge, Name = TestConstants.NPOCO_InsertDogName }; //Act repository.Add(dog); //Assert DataTable table = DataUtil.GetTable(TestConstants.NPOCO_DatabaseName, TestConstants.NPOCO_TableName); DataRow row = table.Rows[table.Rows.Count - 1]; Assert.AreEqual(TestConstants.NPOCO_InsertDogAge, row["Age"]); Assert.AreEqual(TestConstants.NPOCO_InsertDogName, row["Name"]); }
public void NPocoRepository_Add_Inserts_Item_Into_DataBase_With_Correct_ColumnValues() { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(TestConstants.NPOCO_RecordCount); var repository = new NPocoRepository<Dog>(_nPocoUnitOfWork, mockCache.Object); var dog = new Dog { Age = TestConstants.NPOCO_InsertDogAge, Name = TestConstants.NPOCO_InsertDogName }; //Act repository.Add(dog); //Assert DataTable table = DataUtil.GetTable(TestConstants.NPOCO_DatabaseName, TestConstants.NPOCO_TableName); DataRow row = table.Rows[table.Rows.Count - 1]; Assert.AreEqual(TestConstants.NPOCO_InsertDogAge, row["Age"]); Assert.AreEqual(TestConstants.NPOCO_InsertDogName, row["Name"]); }
public void NPocoRepository_Find_Overload_Returns_Correct_Rows() { //Arrange var count = 4; var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(TestConstants.PETAPOCO_RecordCount); var repository = new NPocoRepository<Dog>(_nPocoUnitOfWork, mockCache.Object); //Act IEnumerable<Dog> dogs = repository.Find((d) => d.Age <= 5); //Assert Assert.AreEqual(count, dogs.Count()); }
public void NPocoRepository_Find_Returns_Correct_Rows(int count, string sqlCondition, object arg) { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(TestConstants.PETAPOCO_RecordCount); var repository = new NPocoRepository<Dog>(_nPocoUnitOfWork, mockCache.Object); //Act IEnumerable<Dog> dogs = repository.Find(sqlCondition, arg); //Assert Assert.AreEqual(count, dogs.Count()); }
public void NPocoRepository_GetAll_Returns_List_Of_Models() { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(5); var repository = new NPocoRepository<Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dogs = repository.GetAll().ToList(); //Assert for (int i = 0; i < dogs.Count(); i++) { Assert.IsInstanceOf<Dog>(dogs[i]); } }
public void NPocoRepository_GetAll_Returns_All_Rows(int count) { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(count); var repository = new NPocoRepository<Dog>(_nPocoUnitOfWork, mockCache.Object); //Act IEnumerable<Dog> dogs = repository.GetAll(); //Assert Assert.AreEqual(count, dogs.Count()); }
public void NPocoRepository_GetById_Returns_Model_With_Correct_Properties() { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(5); var repository = new NPocoRepository<Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dog = repository.GetById(TestConstants.NPOCO_ValidDogId); //Assert Assert.AreEqual(TestConstants.NPOCO_ValidDogAge, dog.Age); Assert.AreEqual(TestConstants.NPOCO_ValidDogName, dog.Name); }
public void NPocoRepository_GetById_Returns_Null_If_InValid_Id() { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(5); var repository = new NPocoRepository<Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dog = repository.GetById(TestConstants.NPOCO_InvalidDogId); //Assert Assert.IsNull(dog); }
public void NPocoRepository_GetByProperty_Returns_Instance_Of_Model_If_Valid_Property() { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(5); var dogName = _dogNames[2]; var repository = new NPocoRepository<Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dog = repository.GetByProperty("Name", dogName).FirstOrDefault(); //Assert Assert.IsInstanceOf<Dog>(dog); }
public void NPocoRepository_GetByProperty_Returns_List_Of_Models_If_Valid_Property(string dogName, int count) { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(5); var repository = new NPocoRepository<Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dogs = repository.GetByProperty("Name", dogName); //Assert Assert.IsInstanceOf<IEnumerable<Dog>>(dogs); Assert.AreEqual(count, dogs.Count()); }
public void NPocoRepository_GetByProperty_Returns_Models_With_Correct_Properties(string dogName) { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(5); var repository = new NPocoRepository<Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dogs = repository.GetByProperty("Name", dogName); //Assert foreach (Dog dog in dogs) { Assert.AreEqual(dogName, dog.Name); } }
public void NPocoRepository_GetByProperty_Returns_Empty_List_If_InValid_Proeprty() { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(5); const string dogName = "Invalid"; var repository = new NPocoRepository<Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dogs = repository.GetByProperty("Name", dogName); //Assert Assert.IsInstanceOf<IEnumerable<Dog>>(dogs); Assert.AreEqual(0, dogs.Count()); }
public void NPocoRepository_GetPage_Returns_List_Of_Models() { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(TestConstants.PAGE_TotalCount); var repository = new NPocoRepository<Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dogs = repository.GetPage(TestConstants.PAGE_First, TestConstants.PAGE_RecordCount); //Assert for (int i = 0; i < dogs.Count(); i++) { Assert.IsInstanceOf<Dog>(dogs[i]); } }
public void NPocoRepository_GetPage_Returns_Models_With_Correct_Properties() { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(TestConstants.PAGE_TotalCount); var repository = new NPocoRepository<Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dogs = repository.GetPage(TestConstants.PAGE_First, TestConstants.PAGE_RecordCount); //Assert var dog = dogs.First(); Assert.AreEqual(_dogAges[0], dog.Age.ToString()); Assert.AreEqual(_dogNames[0], dog.Name); }
public void NPocoRepository_GetPage_Returns_Correct_Page(int pageIndex, int pageSize, int firstId) { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(TestConstants.PAGE_TotalCount); var repository = new NPocoRepository<Dog>(_nPocoUnitOfWork, mockCache.Object); //Act var dogs = repository.GetPage(pageIndex, pageSize); //Assert var dog = dogs.First(); Assert.AreEqual(firstId, dog.ID); }
public void NPocoRepository_Update_Updates_Item_With_Correct_ID() { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(TestConstants.NPOCO_RecordCount); var repository = new NPocoRepository<Dog>(_nPocoUnitOfWork, mockCache.Object); var dog = new Dog { ID = TestConstants.NPOCO_UpdateDogId, Age = TestConstants.NPOCO_UpdateDogAge, Name = TestConstants.NPOCO_UpdateDogName }; //Act repository.Update(dog); //Assert DataTable table = DataUtil.GetTable(TestConstants.NPOCO_DatabaseName, TestConstants.NPOCO_TableName); foreach (DataRow row in table.Rows) { if ((int)row["ID"] == TestConstants.NPOCO_UpdateDogId) { Assert.AreEqual(TestConstants.NPOCO_UpdateDogAge, row["Age"]); Assert.AreEqual(TestConstants.NPOCO_UpdateDogName, row["Name"]); } } }
public void NPocoRepository_Delete_Does_Nothing_With_Invalid_ID() { //Arrange var mockCache = new Mock<ICacheProvider>(); SetUpDatabase(TestConstants.NPOCO_RecordCount); var repository = new NPocoRepository<Dog>(_nPocoUnitOfWork, mockCache.Object); var dog = new Dog { ID = TestConstants.NPOCO_InvalidDogId, Age = TestConstants.NPOCO_DeleteDogAge, Name = TestConstants.NPOCO_DeleteDogName }; //Act repository.Delete(dog); //Assert //Assert int actualCount = DataUtil.GetRecordCount(TestConstants.NPOCO_DatabaseName, TestConstants.NPOCO_TableName); Assert.AreEqual(TestConstants.NPOCO_RecordCount, actualCount); }