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;
}
}
