/// <summary>
/// Deleted a musician; this is not the most efficient way to edit a record; just demonstrating the repository in action.
/// </summary>
static void DeleteMusician()
{
using (var db = new DB_Bands())
{
var repo = new MusicianRepository(db);
var random = new Random();
var musicians = repo.GetAll();
var index = random.Next(0, musicians.Count);
var musicianId = musicians[index].MusicianId;
var randomMusician = repo.GetById(musicianId);
repo.Delete(randomMusician);
repo.Save();
Console.WriteLine("Deleted: " + randomMusician.Name);
}
Console.WriteLine("");
}
static void DeleteAllDatabaseRecords()
{
using (var db = new DB_Bands())
{
var musicianRepo = new MusicianRepository(db);
var bandRepo = new BandRepository(db);
var musicians = musicianRepo.GetAll();
foreach (var musician in musicians)
{
musicianRepo.Delete(musician);
}
musicianRepo.Save();
var bands = bandRepo.GetAll();
foreach (var band in bands)
{
bandRepo.Delete(band);
}
bandRepo.Save();
}
}