private static void AddRelationships() { using (var db = new MusicStoreDbContext()) { var albums = db.Albums.ToList(); var artists = db.Artists.ToList(); var songs = db.Songs.ToList(); albums[0].Artists.Add(artists[0]); albums[0].Artists.Add(artists[1]); songs[0].Artist = artists[0]; songs[1].Artist = artists[1]; songs[2].Artist = artists[1]; songs[0].Album = albums[0]; songs[1].Album = albums[0]; songs[2].Album = albums[0]; db.SaveChanges(); } Console.WriteLine("Relationships are successfully added!"); }
public VenueEFRepository(MusicStoreDbContext db) { _db = db; }
public MusicianEFRepository(MusicStoreDbContext db) { _db = db; }
private static void UpdateSong(int id) { using (var db = new MusicStoreDbContext()) { var song = db.Songs.First(x => x.Id == id); song.Year = 190; MusicStoreClient.Update(id, song); } }
private static void UpdateArtist(int id) { using (var db = new MusicStoreDbContext()) { var artist = db.Artists.First(x => x.Id == id); artist.Country = "Brazil"; MusicStoreClient.Update(id, artist); } }
private static void UpdateAlbum(int id) { using (var db = new MusicStoreDbContext()) { var album = db.Albums.First(x => x.Id == id); album.Year = 2; MusicStoreClient.Update(id, album); } }
public static ShoppingCart GetCart(MusicStoreDbContext db, string cartId) => new ShoppingCart(db, cartId);
public static ShoppingCart GetCart(MusicStoreDbContext db, HttpContext context) => GetCart(db, GetCartId(context));
public ShoppingCart(MusicStoreDbContext db, string id) { this._db = db; this._shoppingCartId = id; }