public static void Log(LogEntry[] logEntry) { using (BadgeDataContext db = new BadgeDataContext(BadgeDataContext.ConnectionString)) { foreach (var entry in logEntry) { db.Entries.InsertOnSubmit(entry); } db.SubmitChanges(); } }
private void LogEntryButton_Tap(object sender, GestureEventArgs e) { using (BadgeDataContext db = new BadgeDataContext(BadgeDataContext.ConnectionString)) { LogEntry entries = new LogEntry { Id = db.Entries.Count() + 1, EntryTypeEnum = LogEntry.GetLastType() == EntryType.In ? EntryType.Out : EntryType.In, Time = DateTime.Now, }; db.Entries.InsertOnSubmit(entries); db.SubmitChanges(); MessageBox.Show(string.Format("Azione {0} alle {1}", entries.EntryTypeEnum, entries.Time.ToString()), "Info", MessageBoxButton.OK); } }
// Code to execute when the application is launching (eg, from Start) // This code will not execute when the application is reactivated private void Application_Launching(object sender, LaunchingEventArgs e) { using (BadgeDataContext db = new BadgeDataContext(BadgeDataContext.ConnectionString)) { if (!db.DatabaseExists()) { db.CreateDatabase(); db.SubmitChanges(); } } }