Example of PaginableCollections and Dapper

Example.cs

using (var connection = connectionFactory.GetConnection())
{
    using(var reader =
        connection.QueryMultiple("<stored procedure>", new {  }, CommandType.StoredProcedure))
    {
        var metadata = reader.Read<Metadata>().First();
        var items = reader.Read<Foo>();

        return 
			new StaticPaginable<Foo>(
				items, 
				metadata.PageNumber, 
				metadata.ItemCountPerPage, 
				metadata.TotalItemCount);
    }
}