public void EFLinqRepository_Add_Inserts_Item_Into_DataBase() { //Arrange SetUpDatabase(TestConstants.EF_RecordCount); var repository = new EFLinqRepository<Dog>(_efUnitOfWork, _cache.Object); var dog = new Dog { Age = TestConstants.EF_InsertDogAge, Name = TestConstants.EF_InsertDogName }; //Act repository.Add(dog); _efUnitOfWork.Commit(); //Assert int actualCount = DataUtil.GetRecordCount(TestConstants.EF_DatabaseName, TestConstants.EF_TableName); Assert.AreEqual(TestConstants.EF_RecordCount + 1, actualCount); }
public void EFLinqRepository_Add_Inserts_Item_Into_DataBase_With_Correct_ID() { //Arrange SetUpDatabase(TestConstants.EF_RecordCount); var repository = new EFLinqRepository <Dog>(_efUnitOfWork, _cache.Object); var dog = new Dog { Age = TestConstants.EF_InsertDogAge, Name = TestConstants.EF_InsertDogName }; //Act repository.Add(dog); _efUnitOfWork.Commit(); //Assert int newId = DataUtil.GetLastAddedRecordID(TestConstants.EF_DatabaseName, TestConstants.EF_TableName, "ID"); Assert.AreEqual(TestConstants.EF_RecordCount + 1, newId); }
public void EFLinqRepository_Add_Inserts_Item_Into_DataBase() { //Arrange SetUpDatabase(TestConstants.EF_RecordCount); var repository = new EFLinqRepository <Dog>(_efUnitOfWork, _cache.Object); var dog = new Dog { Age = TestConstants.EF_InsertDogAge, Name = TestConstants.EF_InsertDogName }; //Act repository.Add(dog); _efUnitOfWork.Commit(); //Assert int actualCount = DataUtil.GetRecordCount(TestConstants.EF_DatabaseName, TestConstants.EF_TableName); Assert.AreEqual(TestConstants.EF_RecordCount + 1, actualCount); }
public void EFLinqRepository_Add_Inserts_Item_Into_DataBase_With_Correct_ColumnValues() { //Arrange SetUpDatabase(TestConstants.EF_RecordCount); var repository = new EFLinqRepository <Dog>(_efUnitOfWork, _cache.Object); var dog = new Dog { Age = TestConstants.EF_InsertDogAge, Name = TestConstants.EF_InsertDogName }; //Act repository.Add(dog); _efUnitOfWork.Commit(); //Assert DataTable table = DataUtil.GetTable(TestConstants.EF_DatabaseName, TestConstants.EF_TableName); DataRow row = table.Rows[table.Rows.Count - 1]; Assert.AreEqual(TestConstants.EF_InsertDogAge, row["Age"]); Assert.AreEqual(TestConstants.EF_InsertDogName, row["Name"]); }
public void EFLinqRepository_Add_Inserts_Item_Into_DataBase_With_Correct_ColumnValues() { //Arrange SetUpDatabase(TestConstants.EF_RecordCount); var repository = new EFLinqRepository<Dog>(_efUnitOfWork, _cache.Object); var dog = new Dog { Age = TestConstants.EF_InsertDogAge, Name = TestConstants.EF_InsertDogName }; //Act repository.Add(dog); _efUnitOfWork.Commit(); //Assert DataTable table = DataUtil.GetTable(TestConstants.EF_DatabaseName, TestConstants.EF_TableName); DataRow row = table.Rows[table.Rows.Count - 1]; Assert.AreEqual(TestConstants.EF_InsertDogAge, row["Age"]); Assert.AreEqual(TestConstants.EF_InsertDogName, row["Name"]); }
public void EFLinqRepository_Add_Inserts_Item_Into_DataBase_With_Correct_ID() { //Arrange SetUpDatabase(TestConstants.EF_RecordCount); var repository = new EFLinqRepository<Dog>(_efUnitOfWork, _cache.Object); var dog = new Dog { Age = TestConstants.EF_InsertDogAge, Name = TestConstants.EF_InsertDogName }; //Act repository.Add(dog); _efUnitOfWork.Commit(); //Assert int newId = DataUtil.GetLastAddedRecordID(TestConstants.EF_DatabaseName, TestConstants.EF_TableName, "ID"); Assert.AreEqual(TestConstants.EF_RecordCount + 1, newId); }