public List <AlbumHasGenre> GetGenres(int albumId) { using (var conn = CreateConnection()) { List <AlbumHasGenre> album = new List <AlbumHasGenre>(); SqlCommand cmd = new SqlCommand("getGenresFromAlbum", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@albumId", SqlDbType.Int, 4).Value = albumId; conn.Open(); using (var reader = cmd.ExecuteReader()) { int albumHasGenreIdIndex = reader.GetOrdinal("Album_has_GenreId"); int albumIdIndex = reader.GetOrdinal("AlbumId"); int genreIndex = reader.GetOrdinal("Genre"); int genreIdIndex = reader.GetOrdinal("GenreId"); while (reader.Read()) { AlbumHasGenre ahg = new AlbumHasGenre(); ahg.Genre = reader.GetString(genreIndex); ahg.Album_has_GenreId = reader.GetInt32(albumHasGenreIdIndex); ahg.GenreId = reader.GetInt32(genreIdIndex); ahg.AlbumId = reader.GetInt32(albumIdIndex); album.Add(ahg); /*album.Add( new AlbumHasGenre * { * Album_has_GenreId = reader.GetInt32(albumHasGenreIdIndex), * GenreId = reader.GetInt32(genreIdIndex), * AlbumId = reader.GetInt32(albumIdIndex), * Genre = reader.GetString(genreIdIndex) * });*/ } return(album); } } }
public List<AlbumHasGenre> GetGenres(int albumId) { using (var conn = CreateConnection()) { List<AlbumHasGenre> album = new List<AlbumHasGenre>(); SqlCommand cmd = new SqlCommand("getGenresFromAlbum", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@albumId", SqlDbType.Int, 4).Value = albumId; conn.Open(); using (var reader = cmd.ExecuteReader()) { int albumHasGenreIdIndex = reader.GetOrdinal("Album_has_GenreId"); int albumIdIndex = reader.GetOrdinal("AlbumId"); int genreIndex = reader.GetOrdinal("Genre"); int genreIdIndex= reader.GetOrdinal("GenreId"); while (reader.Read()) { AlbumHasGenre ahg = new AlbumHasGenre(); ahg.Genre = reader.GetString(genreIndex); ahg.Album_has_GenreId = reader.GetInt32(albumHasGenreIdIndex); ahg.GenreId = reader.GetInt32(genreIdIndex); ahg.AlbumId = reader.GetInt32(albumIdIndex); album.Add(ahg); /*album.Add( new AlbumHasGenre { Album_has_GenreId = reader.GetInt32(albumHasGenreIdIndex), GenreId = reader.GetInt32(genreIdIndex), AlbumId = reader.GetInt32(albumIdIndex), Genre = reader.GetString(genreIdIndex) });*/ } return album; } } }