public void GetAllQueryable_Update_GetById() { using (var ctx = new eJukeboxContext()) { var repo = new SongRepository(ctx); var table = repo.Table(); var entity = table.FirstOrDefault(x => x.Title.Contains("the")); var result = entity.ToDomain(); //var result = repo.Table().FirstOrDefault(x => x.Title.Contains("the")).ToDomain(); //var result = ctx.Song.FirstOrDefault(x => x.Title.Contains("the")).ToDomain(); if (result != null) { var originalTitle = result.Title; //Save a test change result.Title = result.Title + "-test"; repo.Update(result); //Reread the record from the db. Should include change. var result2 = repo.Get(result.Id); Assert.IsTrue(result2.Title == result.Title); //Restore original value result2.Title = originalTitle; repo.Update(result2); } else { Assert.Inconclusive("Can't find record to test with."); } } }
public void LazyLoading() { using (eJukeboxContext ctx = new eJukeboxContext()) { Data.Models.Gig gig2 = ctx.Gig.SingleOrDefault(x => x.Id == 1); Assert.IsTrue(gig2.GigSong.Count > 0); } }
public void DbContext() { using (var db = new eJukeboxContext()) { var result = db.Song.ToList(); Assert.IsFalse(result.Count == 0); } }
public void GetWithLambda() { using (var ctx = new eJukeboxContext()) { var result = ctx.Song.Where(x => x.Title.Contains("the")).ToDomainList(); Assert.IsInstanceOfType(result, typeof(IList <Domain.Song>)); Assert.IsNotInstanceOfType(result, typeof(IList <Data.Models.Song>)); Assert.IsTrue(result.Count > 0); } }
public void Table() { using (var ctx = new eJukeboxContext()) { var repo = new SongRepository(ctx); var table = repo.Table(); var query = table.Where(x => x.Title.Contains("the")); var result = query.ToDomainList(); Assert.IsTrue(result.Count > 0); } }