private LiveEntry GetEntry() { LiveEntry query = (from row in livedb.entry where row.key == "mainkey" select row).SingleOrDefault(); if (query == null) { LiveEntry first = new LiveEntry(); first.date = "00.00.1234"; first.timein = "00:00"; first.timeout = "00:00"; first.lunchin = "00:00"; first.lunchout = "00:00"; first.state = 0; first.key = "mainkey"; livedb.entry.InsertOnSubmit(first); livedb.SubmitChanges(); query = (from row in livedb.entry where row.key == "mainkey" select row).SingleOrDefault(); } return query; }
private void UpdateLiveDB(LiveEntry entry) { LiveEntry query = (from row in livedb.entry where row.key == "mainkey" select row).SingleOrDefault(); query = entry; livedb.SubmitChanges(); }