MVC3 - Sorting db query when using Include

Question

I'm doing a site where i've been using the MvcMusicStore as a base.

I want to get all the albums from a specific genre, and order these by Artist name. I can't really figure out how to order by Artist name.

My models:

    public partial class Genre
    {
        public int GenreId { get; set; }
        public string Name { get; set; }
        public string Description { get; set; }

        public ICollection Albums { get; set; }
        public ICollection Artists { get; set; }
    }

    public class Artist
    {
        public int ArtistId { get; set; }
        public string Name { get; set; }
    }

    public class Album
    {
        public int AlbumId { get; set; }
        public int GenreId { get; set; }
        public int ArtistId { get; set; }
        public string Title { get; set; }
        public string Price { get; set; }
        public string AlbumArtUrl { get; set; }
        public string Description { get; set; }

        public virtual Genre Genre { get; set; }
        public virtual Artist Artist { get; set; }
    }

    My Controller:

    public ActionResult Index(string genre = "CD/LP")
    {
        var genreModel = storeDb.Genres.Include("Albums").Include("Artists")
                .Where(g => g.Name == genre).FirstOrDefault();

        return View(genreModel);
    }

How can I order the results by Artist name?

Andrew Savinykh · Accepted Answer · 2012-02-03 02:49:43Z

4

storeDb.Albums.Where(a => a.Genre.Name == genre).OrerBy(a => a.Artist.Name)

edited Feb 3, 2012 at 2:49

Andrew Savinykh

26.7k20 gold badges110 silver badges168 bronze badges

answered Feb 2, 2012 at 22:36

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MVC3 - Sorting db query when using Include

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related