public void All_LimitSpecification() { var albums = new Albums(); var allRows = albums.All(limit: 10).ToList(); Assert.AreEqual(10, allRows.Count); }
public void All_NoParameters() { var albums = new Albums(); var allRows = albums.All().ToList(); Assert.AreEqual(347, allRows.Count); foreach (var a in allRows) { Console.WriteLine("{0} {1}", a.AlbumId, a.Title); } }
public void All_WhereSpecification_OrderBySpecification_LimitSpecification() { var albums = new Albums(); var allRows = albums.All(limit: 6, orderBy: "Title DESC", where : "ArtistId=@0", args: 90).ToList(); Assert.AreEqual(6, allRows.Count); string previous = string.Empty; foreach (var r in allRows) { string current = r.Title; Assert.IsTrue(string.IsNullOrEmpty(previous) || string.Compare(previous, current) > 0); previous = current; } }