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);
}
