public static bool CreateDatabase(bool addsampledata = false) { try { using (var db = new IoTDbContext()) { db.Database.EnsureDeleted(); var result = db.Database.EnsureCreated(); if (addsampledata) { db.Add(new Models.TemperatureSensorDescriptor(new string[] { "Temperature", "0", "0", "Window", "Left Sensor", "20.0", "C" })); db.Add(new Models.PressureSensorDescriptor(new string[] { "Pressure", "0", "0", "Window", "Left Sensor", "1024.0", "mb" })); db.SaveChanges(); } return(true); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(false); } }
public static bool ExistsDatabase() { try { using (var db = new IoTDbContext()) { return(db.Database.CanConnect()); } } catch { return(false); } }
public static void InsertData(object sensor) { using (var db = new IoTDbContext()) { try { db.Add(sensor); db.SaveChanges(); } catch (Exception ex) { Debug.WriteLine($"Error in DataService.InsertData {ex.Message}"); } } }