Retrieving next and previous records with Simple.Data

gistfile1.cs

// This code works, but somehow it looks like there is a better and more elegant solution for it.

IEnumerable<Models.Photo> previous = DB.Photos
                                       .FindAll(DB.Photos.Published == true && DB.Photos.DatePublished < currentPhoto.DatePublished.Value)
                                       .OrderByDatePublishedDescending()
                                       .Take(1)
                                       .Cast<Models.Photo>();

int? previousPhotoId = null;
Models.Photo previousPhoto = previous.FirstOrDefault();

if (previousPhoto != null)
{
	previousPhotoId = previousPhoto.Id;
}

IEnumerable<Models.Photo> next = DB.Photos
                                   .FindAll(DB.Photos.Published == true && DB.Photos.DatePublished > currentPhoto.DatePublished.Value)
                                   .OrderByDatePublished()
                                   .Take(1)
                                   .Cast<Models.Photo>();

int? nextPhotoId = null;
Models.Photo nextPhoto = next.FirstOrDefault();

if (nextPhoto != null)
{
	nextPhotoId = nextPhoto.Id;
}