public List <Model.NetworkEvent> GetEventsInRange(DateTimeOffset startTime, DateTimeOffset endTime)
{
var mapper = new Mapping();
var list = new List <Model.NetworkEvent>();
using (var ctx = new NetworkTrackerContext())
{
var events = ctx.NetworkEvents.Include(x => x.EventType);
var eventList = events.ToList();
//foreach (var e in events)
//{
// list.Add(new Model.NetworkEvent()
// {
// ID = e.ID,
// EventType = mapper.Map(e.EventType),
// CreateDate = e.CreateTime,
// Value = e.Value
// });
//}
}
return(list);
}
NetworkTrackerContext InitializeWithProvider()
{
var dbPath = GetRandomFileName();
var options = new DbContextOptionsBuilder <NetworkTrackerContext>();
options.UseSqlite(dbPath);
using (var ctx = new NetworkTrackerContext(options.Options))
{
ctx.Database.EnsureDeleted();
ctx.Database.EnsureCreated();
}
return(new NetworkTrackerContext(options.Options));
}
NetworkTrackerContext InitializeWithProvider()
{
var path = @"Data Source=.\tests.db";
var options = new DbContextOptionsBuilder <NetworkTrackerContext>();
options.UseSqlite(path);
using (var ctx = new NetworkTrackerContext(options.Options))
{
ctx.Database.EnsureDeleted();
ctx.Database.EnsureCreated();
}
return(new NetworkTrackerContext(options.Options));
}
