//Example - paged & filtered list:
public Page <NoKeyNonDistinctObject> PagedFilteredList(string str1, string str2, long page, long itemsPerPage)
{
return(db.Page <NoKeyNonDistinctObject>(page, itemsPerPage, "WHERE (v1=@p1) AND (v2=@p2)", new { p1 = str1, p2 = str2 }));
}
