public EmployeeTest()
{
string path = System.Environment.CurrentDirectory.ToString();
db = new VfpDBContext($"{path}\\Sinca.dbc");
//db = new VfpDBContext();
}
static void Main(string[] args)
{
string path = System.Environment.CurrentDirectory.ToString();
using (var db = new VfpDBContext($"{path}\\Sinca.dbc"))
{
// Create
Console.WriteLine("Add New Employee: ");
db.Employees.Add(new Employee {
FirstName = "John", LastName = "Doe", Age = 55
});
db.SaveChanges();
Console.WriteLine("Employee has been added sucessfully.");
// Read
Console.WriteLine("Querying table for that employee.");
var employee = db.Employees
.OrderBy(b => b.Id)
.First();
Console.WriteLine("The employee found: {0} {1} and is {2} years old.", employee.FirstName, employee.LastName, employee.Age);
// Update
Console.WriteLine("Updating the employee first name and age.");
employee.FirstName = "Louis";
employee.Age = 90;
Console.WriteLine("Newly updated employee is: {0} {1} and is {2} years old.", employee.FirstName, employee.LastName, employee.Age);
db.SaveChanges();
// Delete
Console.WriteLine("Delete the employee.");
db.Employees.Remove(employee);
db.SaveChanges();
Console.ReadKey();
}
}