public void BasicSelect()
{
var table = new Artists();
var artists = table.All(columns: "Name");
var acdc = artists.Where(x => x.Name == "AC/DC");
//var alanis = artists.Where(x => x.Name.StartsWith("Alanis"));
}
public void BasicInsert()
{
dynamic artists = new Artists();
dynamic artist = artists.Insert(new { Name = "ArtistName" });
Assert.That(artist.ID, Is.GreaterThan(0));
Assert.AreEqual("ArtistName", artist.Name);
}
public void BasicPaging()
{
var table = new Artists();
var artistsPage1 = table.Paged();
//var artistsPage2 = table.Paged(orderBy: "name desc", currentPage: 2);
var artistsPage2 = table.Paged(orderBy: "name desc", currentPage: 2);
var artistsPage200 = table.Paged(currentPage: 200);
foreach (dynamic item in artistsPage1.Items) { };
foreach (dynamic item in artistsPage2.Items) { };
foreach (dynamic item in artistsPage200.Items) { };
}
public void BasicUpdate()
{
var artists = new Artists();
artists.Update( new { Name = "Not AC/DC" },1);
artists.Update(new { Name = "AC/DC" }, 1);
}
