How Do I Create A Method In Asp.Net Mvc That Returns A List Of Recommendations To The User?

See more:

ASP.NET

MVC3

MVC4

MVC5

I have created the db and tables and a model classes of each table having the same properties as column name. How do i create a method in controller class [Asp.Net MVC] to return a list of recommendation of music to the user i.e the musics that are in the library of users friends. Each user has a list of music tracks in their library and each user has a list of friends(Users). Recommendations are all the music tracks, which are owned by the user’s immediate friends but not by the user. Similary using a MusicInfoDBContext class and Dbsets: public DbSet<Users> Users{ get; set; } Following is the signature of the method:

List<Music> getMusicRecommendations(User user)
and the DBScript is as follows:


CREATE DATABASE OnlineMusicStore
  CREATE TABLE Users(
    ID int primary key identity(1,1),
    Username nvarchar(255)
    )

    CREATE TABLE Music
    (
    ID int primary key identity(1,1),
    MusicName nvarchar(255),
    )

    CREATE TABLE Users_Music
    (
    UserId int foreign key references Users(ID),
    MusicId int foreign key references Music(ID)
    )

    CREATE TABLE Users_Friends
    (
    UserId int foreign key references Users(ID),
    FriendId int foreign key references Users(ID)
    )
 public class Users
    {
        public int ID { get; set; }
        public string UserName { get; set; }
    }
  public class Music
    {
        public int ID { get; set; }
        public string MusicName { get; set; }
    }
 public class Users_Music
    {
        public int UserId { get; set; }
        public int MusicId { get; set; }
    }
  public class Users_Friends
    {
        public int UserId { get; set; }
        public int FriendId { get; set; }
    }

Can anyone elaborate the solution as i can understand it better. One of my Friend suggested using:

recommendations = AllFriendsMusicList.Except(user.MusicList);