public void UpdateWithDictionary()
{
var repo = new RepositoryWithCaching <Employee, int>(DataSource, EmployeeTableName);
var emp1 = new Dictionary <string, object>(StringComparer.OrdinalIgnoreCase)
{
{ "FirstName", "Tom" }, { "LastName", "Jones" }, { "Title", "President" }
};
var echo1 = repo.Insert(emp1);
Assert.AreNotEqual(0, echo1.EmployeeKey, "EmployeeKey was not set");
Assert.AreEqual(emp1["FirstName"], echo1.FirstName, "FirstName");
Assert.AreEqual(emp1["LastName"], echo1.LastName, "LastName");
Assert.AreEqual(emp1["Title"], echo1.Title, "Title");
var emp2 = new Dictionary <string, object>(StringComparer.OrdinalIgnoreCase)
{
{ "EmployeeKey", echo1.EmployeeKey }, { "LastName", "Brown" }
};
repo.Update(emp2);
var echo2 = repo.Get(echo1.EmployeeKey.Value);
//these were changed
Assert.AreEqual(echo1.EmployeeKey, echo2.EmployeeKey, "EmployeeKey was not set");
Assert.AreEqual(emp2["LastName"], echo2.LastName, "LastName");
//these should be unchanged
Assert.AreEqual(emp1["FirstName"], echo2.FirstName, "FirstName");
Assert.AreEqual(emp1["Title"], echo2.Title, "Title");
repo.Delete(echo1.EmployeeKey.Value);
}
public void BasicCrud()
{
var repo = new RepositoryWithCaching <Employee, int>(DataSource, EmployeeTableName);
var emp1 = new Employee()
{
FirstName = "Tom", LastName = "Jones", Title = "President"
};
var echo1 = repo.Insert(emp1);
Assert.AreNotEqual(0, echo1.EmployeeKey, "EmployeeKey was not set");
Assert.AreEqual(emp1.FirstName, echo1.FirstName, "FirstName");
Assert.AreEqual(emp1.LastName, echo1.LastName, "LastName");
Assert.AreEqual(emp1.Title, echo1.Title, "Title");
echo1.MiddleName = "G";
var updatedEcho1 = repo.Update(echo1);
var cached1 = repo.Get(echo1.EmployeeKey.Value);
Assert.AreSame(updatedEcho1, cached1, "Item should have been cached");
var emp2 = new Employee()
{
FirstName = "Lisa", LastName = "Green", Title = "VP Transportation", ManagerKey = echo1.EmployeeKey
};
var echo2 = repo.Insert(emp2);
Assert.AreNotEqual(0, echo2.EmployeeKey, "EmployeeKey was not set");
Assert.AreEqual(emp2.FirstName, echo2.FirstName, "FirstName");
Assert.AreEqual(emp2.LastName, echo2.LastName, "LastName");
Assert.AreEqual(emp2.Title, echo2.Title, "Title");
Assert.AreEqual(emp2.ManagerKey, echo2.ManagerKey, "ManagerKey");
var list = repo.GetAll();
Assert.IsTrue(list.Any(e => e.EmployeeKey == echo1.EmployeeKey), "Employee 1 is missing");
Assert.IsTrue(list.Any(e => e.EmployeeKey == echo2.EmployeeKey), "Employee 2 is missing");
var list2 = repo.GetAll();
Assert.AreSame(list, list2, "GetAll should have been cached");
var cached1b = repo.Get(echo1.EmployeeKey.Value);
Assert.AreNotSame(echo1, cached1b, "Cached item was replaced");
Assert.IsTrue(list.Contains(cached1b), "Single item should have been contained in the list we previously cached.");
var get1 = repo.Get(echo1.EmployeeKey.Value);
Assert.AreEqual(echo1.EmployeeKey, get1.EmployeeKey);
repo.Delete(echo2.EmployeeKey.Value);
repo.Delete(echo1.EmployeeKey.Value);
var list3 = repo.GetAll();
Assert.AreEqual(list.Count - 2, list3.Count);
}
public void InsertWithDictionary()
{
var repo = new RepositoryWithCaching <Employee, int>(DataSource, EmployeeTableName);
var emp1 = new Dictionary <string, object>(StringComparer.OrdinalIgnoreCase)
{
{ "FirstName", "Tom" }, { "LastName", "Jones" }, { "Title", "President" }
};
var echo1 = repo.Insert(emp1);
Assert.AreNotEqual(0, echo1.EmployeeKey, "EmployeeKey was not set");
Assert.AreEqual(emp1["FirstName"], echo1.FirstName, "FirstName");
Assert.AreEqual(emp1["LastName"], echo1.LastName, "LastName");
Assert.AreEqual(emp1["Title"], echo1.Title, "Title");
repo.Delete(echo1.EmployeeKey.Value);
}
