如何在C#中填充具有列表类型成员的对象

问题描述

你好，

我有一个Genere类别，如下所示

Hello,

I have a Genere Class as below

public class Genre
    {
        public int GenreId { get; set; }
        public string Name { get; set; }
        public string Description {get; set;}
        public List<Album> Albums { get; set; }
    }

我正在尝试通过在DAL类中使用以下代码来填充流派对象:

I am trying to populate the Genre objet by using below code in my DAL class

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();
}

我的问题是如何填充流派类别的专辑成员.
在我的数据库中，一个流派可以有多个专辑，并且我必须使用企业库的数据访问应用程序数据块.

在此先谢谢您.

My Question is how i can populate the Albums member of Genre Class.
In my database one Genre can have multiple Albums and I have to Use Enterprise Library''s Data Access Application Data Block.

Thanks in Advance.

推荐答案

这篇关于如何在C#中填充具有列表类型成员的对象的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！