Retrieving next and previous records with Simple.Data

gistfile1.cs

// Checked blog at http://blog.markrendle.net/2011/05/23/simple-data-0-6-5/
// and code at https://github.com/markrendle/Simple.Data/blob/master/Simple.Data/SimpleQuery.cs

int? previousPhotoId = DB.Photos.Query()
                                .Select(DB.Photos.Id)
                                .Where(DB.Photos.Published == true && DB.Photos.DatePublished < currentPhoto.DatePublished.Value)
                                .OrderByDatePublishedDescending()
                                .ToScalarOrDefault<int?>();

int? nextPhotoId = DB.Photos.Query()
                                .Select(DB.Photos.Id)
                                .Where(DB.Photos.Published == true && DB.Photos.DatePublished > currentPhoto.DatePublished.Value)
                                .OrderByDatePublishedAscending()
                                .ToScalarOrDefault<int?>();