/// <summary> /// Returns a collection of all Notes from the database. /// </summary> /// <returns></returns> public static List <Note> GetAllNotes() { List <Note> notes; using (var db = new NotesContext()) { notes = db.Notes.ToList(); } return(notes); }
/// <summary> /// Asynchronously inserts a new note into the database. /// </summary> public static async void InsertNoteAsync(Note note) { using (var db = new NotesContext()) { // If the database contains the note, do not insert it again // Example: we take a note out of the database, then try to insert it again if (note.Id != 0 && db.Notes.Select(x => x.Id == note.Id).Count() == 0) { db.Notes.Add(note); await db.SaveChangesAsync(); } } }