public void SelectTest()
{
MapTypes();
Create();
Employee employee = new Employee();
employee.Firstname = "Susana";
employee.LastName = "Mendoza";
employee.BirthDate = new DateTime(1980, 1, 1);
employee.Salary = 1000;
DataBase.Table<int, Employee>().Add(new KeyValuePair<int, Employee>(0, employee));
var e = DataBase.Table<int, Employee>()[employee.Id];
Assert.AreEqual(e.LastName, employee.LastName);
Drop();
}
public void Update()
{
MapTypes();
Create();
Employee employee = new Employee();
employee.Firstname = "Susana";
employee.LastName = "Mendoza";
employee.BirthDate = new DateTime(1980, 1, 1);
employee.Salary = 1000;
DataBase.Table<int, Employee>().Add(new KeyValuePair<int, Employee>(0, employee));
employee.Salary = 3000;
employee.BirthDate = new DateTime(2000, 1, 1);
DataBase.Table<int, Employee>()[employee.Id] = employee;
Drop();
}
public void SelectTest()
{
MapTypes();
Create();
Employee employee = new Employee();
employee.Firstname = "Yunuen";
employee.LastName = "Fernandez";
employee.BirthDate = new DateTime(1990, 3, 13);
employee.Salary = 2000;
//DataBase.Table<int, Employee>().Add(new KeyValuePair<int, Employee>(0, employee));
DataBase.Insert(employee);
int generatedId = employee.Id;
//var e = DataBase.Table<int, Employee>()[employee.Id];
employee = new Employee();
employee.Id = generatedId;
DataBase.Select(employee);
Console.WriteLine("Name: " + employee.Firstname);
Assert.AreEqual("Fernandez", employee.LastName);
Drop();
}
