public void ImportObservations() { var fileName = @"D:\Development\Observations.csv"; using (StreamReader reader = new StreamReader(File.OpenRead(fileName))) { using (VaderContext ctx = new VaderContext()) { while (!reader.EndOfStream) { var line = reader.ReadLine(); var parts = line.Split(';'); var deviceId = int.Parse(parts[1].Replace("\"", string.Empty)); var datetime = DateTime.Parse(parts[2].Replace("\"", string.Empty)); var temperature = decimal.Parse(parts[3].Replace("\"", string.Empty).Replace(".", ",")); var observation = new Observations { DeviceId = deviceId, ObservationTime = datetime, TemperatureInCelsius = temperature }; ctx.Observations.Add(observation); ctx.SaveChanges(); } } } }
public static void AddTemperatureObservation(int deviceId, decimal temperature) { using (VaderContext ctx = new VaderContext()) { var observation = new Observations() { DeviceId = deviceId, ObservationTime = DateTime.UtcNow, TemperatureInCelsius = temperature }; ctx.Observations.Add(observation); ctx.SaveChanges(); } }