public void NewBand() { using (var db = new BandsContext()) { Console.WriteLine(); Console.WriteLine("Add a band to the database:"); string newBand = Console.ReadLine(); if (newBand != "") { db.Bands.Add(new Band { Name = newBand }); var count = db.SaveChanges(); Console.WriteLine("{0} records saved to database", count); } // pause Console.ReadLine(); } }
public void DeleteBand() { using (var db = new BandsContext()) { Console.WriteLine(); Console.WriteLine("Enter the band's name to delete"); string userInput = Console.ReadLine(); var bandToDelete = db.Bands.Where(b => b.Name.ToUpper() == userInput.ToUpper()).FirstOrDefault(); if (bandToDelete != null) { Console.WriteLine("Deleting {0} from the database", bandToDelete.Name); db.Remove(bandToDelete); db.SaveChanges(); Console.ReadLine(); } else { Console.WriteLine("Could not find band: {0}", userInput); Console.ReadLine(); } } }