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)); }