public void PetaPocoRepository_Delete_Deletes_Item_From_DataBase_With_Correct_ID() { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository <Dog>(db, mapper); var dog = new Dog { ID = Constants.PETAPOCO_DeleteDogId, Age = Constants.PETAPOCO_DeleteDogAge, Name = Constants.PETAPOCO_DeleteDogName }; //Act repository.Delete(dog); //Assert DataTable table = DataUtil.GetTable(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); foreach (DataRow row in table.Rows) { Assert.IsFalse((int)row[Constants.TABLENAME_Key] == Constants.PETAPOCO_DeleteDogId); } }
public void PetaPocoRepository_Update_Overload_Updates_Item_With_Correct_ID() { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository <Dog>(db, mapper); //Act repository.Update("SET Age=@1, Name=@2 WHERE ID=@0", Constants.PETAPOCO_UpdateDogId, Constants.PETAPOCO_UpdateDogAge, Constants.PETAPOCO_UpdateDogName); //Assert DataTable table = DataUtil.GetTable(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); foreach (DataRow row in table.Rows) { if ((int)row[Constants.TABLENAME_Key] == Constants.PETAPOCO_UpdateDogId) { Assert.AreEqual(Constants.PETAPOCO_UpdateDogAge, row["Age"]); Assert.AreEqual(Constants.PETAPOCO_UpdateDogName, row["Name"]); } } }
public void PetaPocoRepository_Add_Inserts_Item_Into_DataBase_With_Correct_ColumnValues() { //Arrange var db = CreatePecaPocoDatabase(); var mapper = new PetaPocoMapper(String.Empty); DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository <Dog>(db, mapper); var dog = new Dog { Age = Constants.PETAPOCO_InsertDogAge, Name = Constants.PETAPOCO_InsertDogName }; //Act repository.Insert(dog); //Assert DataTable table = DataUtil.GetTable(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); DataRow row = table.Rows[table.Rows.Count - 1]; Assert.AreEqual(Constants.PETAPOCO_InsertDogAge, row["Age"]); Assert.AreEqual(Constants.PETAPOCO_InsertDogName, row["Name"]); }
public void PetaPoco_Update_Overload_Updates_Item() { //Arrange DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); //Act using (var dataContext = new PetaPocoDataContext(ConnectionStringName)) { IRepository <Dog> dogRepository = dataContext.GetRepository <Dog>(); //Act dogRepository.Update("SET Age=@1, Name=@2 WHERE ID=@0", Constants.PETAPOCO_UpdateDogId, Constants.PETAPOCO_UpdateDogAge, Constants.PETAPOCO_UpdateDogName); } //Assert DataTable table = DataUtil.GetTable(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); Assert.AreEqual(Constants.PETAPOCO_RecordCount, table.Rows.Count); foreach (DataRow row in table.Rows) { if ((int)row["ID"] == Constants.PETAPOCO_UpdateDogId) { Assert.AreEqual(row["Age"], Constants.PETAPOCO_UpdateDogAge); Assert.AreEqual(row["Name"], Constants.PETAPOCO_UpdateDogName); } } }
public void PetaPoco_Update_Updates_Item_Using_FluentMapper() { //Arrange DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var dog = new Dog { ID = Constants.PETAPOCO_UpdateDogId, Age = Constants.PETAPOCO_UpdateDogAge, Name = Constants.PETAPOCO_UpdateDogName }; //Act using (var dataContext = new PetaPocoDataContext(ConnectionStringName, String.Empty, _mappers)) { IRepository <Dog> dogRepository = dataContext.GetRepository <Dog>(); //Act dogRepository.Update(dog); } //Assert DataTable table = DataUtil.GetTable(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); Assert.AreEqual(Constants.PETAPOCO_RecordCount, table.Rows.Count); foreach (DataRow row in table.Rows) { if ((int)row["ID"] == Constants.PETAPOCO_UpdateDogId) { Assert.AreEqual(row["Age"], Constants.PETAPOCO_UpdateDogAge); Assert.AreEqual(row["Name"], Constants.PETAPOCO_UpdateDogName); } } }
public void PetaPocoRepository_Delete_Deletes_Item_From_DataBase_With_Correct_ID_Using_FluentMapper() { // Arrange var db = this.CreatePecaPocoDatabase(); var mapper = new FluentMapper <Dog>(string.Empty); mapper.TableName(Constants.PETAPOCO_DogTableName); mapper.PrimaryKey("ID"); mapper.Property(d => d.ID, "ID"); mapper.Property(d => d.Age, "Age"); mapper.Property(d => d.Name, "Name"); DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository <Dog>(db, mapper); var dog = new Dog { ID = Constants.PETAPOCO_DeleteDogId, Age = Constants.PETAPOCO_DeleteDogAge, Name = Constants.PETAPOCO_DeleteDogName, }; // Act repository.Delete(dog); // Assert DataTable table = DataUtil.GetTable(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); foreach (DataRow row in table.Rows) { Assert.IsFalse((int)row[Constants.TABLENAME_Key] == Constants.PETAPOCO_DeleteDogId); } }
public void PetaPocoRepository_Add_Inserts_Item_Into_DataBase_With_Correct_ColumnValues_Using_FluentMapper() { // Arrange var db = this.CreatePecaPocoDatabase(); var mapper = new FluentMapper <Dog>(string.Empty); mapper.TableName(Constants.PETAPOCO_DogTableName); mapper.PrimaryKey("ID"); mapper.Property(d => d.ID, "ID"); mapper.Property(d => d.Age, "Age"); mapper.Property(d => d.Name, "Name"); DataUtil.SetUpDatabase(Constants.PETAPOCO_RecordCount); var repository = new PetaPocoRepository <Dog>(db, mapper); var dog = new Dog { Age = Constants.PETAPOCO_InsertDogAge, Name = Constants.PETAPOCO_InsertDogName, }; // Act repository.Insert(dog); // Assert DataTable table = DataUtil.GetTable(Constants.PETAPOCO_DatabaseName, Constants.PETAPOCO_DogTableName); DataRow row = table.Rows[table.Rows.Count - 1]; Assert.AreEqual(Constants.PETAPOCO_InsertDogAge, row["Age"]); Assert.AreEqual(Constants.PETAPOCO_InsertDogName, row["Name"]); }