public class Genre { public int GenreId { get; set; } public string Name { get; set; } public string Description {get; set;} public List<Album> Albums { get; set; } }
public List<Genre> GetAlbumByGenreName(string genre) { IList<Genre> genres = new List<Genre>(); IList<Album> albums = new List<Album>(); Database db = DatabaseFactory.CreateDatabase(); DbConnection cn = db.CreateConnection(); cn.Open(); DbCommand cmd = cn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "Select g.GenreId,Name,Description, A.Title from Genre g Inner Join Album A on g.GenreId = a.GenreId Where g.Name = '" + genre + "'"; using (SqlDataReader dr = cmd.ExecuteReader() as SqlDataReader) { while (dr.Read()) { genres.Add(new Genre { GenreId = dr.GetInt32(0), Name = dr.GetString(1), Description = dr.GetString(2)//, //Albums = dr.GetString(3) }); } } return genres.ToList(); }
object data = dr["myColumnName"];
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)