Where to insert 'orderby' expression in this linq-to-sql query

Question

var result = db.PhotoAlbums.Select(albums => new PhotoAlbumDisplay
            {
                AlbumID = albums.AlbumID,
                Title = albums.Title,
                Date = albums.Date,
                PhotoID = albums.Photos.Select(photo => photo.PhotoID).FirstOrDefault().ToString()
            });

Wherever I try to put orderby albums.AlbumID descending I get error. Someone knows solution?
Thanks!

Answer 1

If you want to use the query syntax, you'll have to start with "from X select" and work from that. In this case it'd be easier to just use the .OrderBy() method to order the results.

Answer 2

This should work:

var result = db.PhotoAlbums.Select(albums => new PhotoAlbumDisplay
            {
                AlbumID = albums.AlbumID,
                Title = albums.Title,
                Date = albums.Date,
                PhotoID = albums.Photos.Select(photo => photo.PhotoID).FirstOrDefault().ToString()
            })
            .OrderByDescending(item => item.AlbumID);

In query syntax:

var result = from albums in db.PhotoAlbums
             orderby albums.AlbumID descending
             select new PhotoAlbumDisplay
             {
                 AlbumID = albums.AlbumID,
                 Title = albums.Title,
                 Date = albums.Date,
                 PhotoID = albums.Photos.Select(photo => photo.PhotoID).FirstOrDefault().ToString()
            };

Answer 3

Is this what you're looking for?

var result = db.PhotoAlbums.Select(albums => new PhotoAlbumDisplay
        {
            AlbumID = albums.AlbumID,
            Title = albums.Title,
            Date = albums.Date,
            PhotoID = albums.Photos.Select(photo => photo.PhotoID).FirstOrDefault().ToString()
        })
        .OrderByDescending(a=>a.AlbumID);