private void ReadEventsTable()
{
try
{
using var db = new EventsContext();
var events = db.Events
.Include("Location")
.OrderBy(e => e.TimeStamp)
.ToList();
events.ForEach(e =>
{
Console.WriteLine($"{e.TimeStamp} - {e.Location.Name}");
});
}
catch (Exception ex)
{
Console.WriteLine("Error reading data: " + ex.Message);
}
}
private void PopulateEventsTable(List <Event> events)
{
using var db = new EventsContext();
db.AddEvents(events);
}
private void PopulateLocationsTable(List <Location> locations)
{
using var db = new EventsContext();
db.AddLocations(locations);
}