Another way of retrieving next and previous records with Simple.Data

gistfile1.cs

// This also works, but again, it doesn't look very elegant

int? previousId;
try
{
    previousId = DB.Photos
                   .FindAll(DB.Photos.Published == true && DB.Photos.DatePublished < currentPhoto.DatePublished.Value)
                   .OrderByDatePublishedDescending()
                   .Take(1)
                   .Select(DB.Photos.Id)
                   .First()
                   .Id;
}
catch
{
    previousId = null;
}