static void DeleteNote() { using (var dbContext = new NoteDbContext()) { var note = dbContext.Notes.Find(2); dbContext.Notes.Remove(note); dbContext.SaveChanges(); } }
static void UpdateNote(int noteId) { Console.WriteLine("Before updating"); GetNote(noteId); using (var dbContext = new NoteDbContext()) { var note = dbContext.Notes.Find(noteId); note.Title = "EF configuration Tips"; note.UpdatedUtc = DateTime.UtcNow; dbContext.SaveChanges(); } Console.WriteLine("After updating"); GetNote(noteId); }
static void CreateNote() { //Insert a new record with ORM (Entity Framework) using (var dbContext = new NoteDbContext()) { // Create notebook var notebook = new Notebook() { Name = "Programming Tips" }; dbContext.Notebooks.Add(notebook); // Create tag var tag = new Tag { Name = "ef" }; dbContext.Tags.Add(tag); // Crate note var note = new Note() { Title = "EF Tips", Content = "How to create entity classes from an existing database...", //CreatedUtc = DateTime.UtcNow, Notebook = notebook }; note.Tags.Add(tag); dbContext.Notes.Add(note); dbContext.SaveChanges(); Console.WriteLine($"New notebook inserted with Id {notebook.Id}"); Console.WriteLine($"New tag inserted with Id {tag.Id}"); Console.WriteLine($"New note inserted with Id {note.Id}"); } }