在数据访问层中如何把多表查询的数据添加到list数据集中

Question

private static IList<ProductInfo> GetOrdersBySql(string safeSQL)
{
List<ProductInfo> list = new List<ProductInfo>();
try
{
SqlDataReader read = DBhelperSQL.GetReader(safeSQL);
if (read.HasRows)
{
while (read.Read())
{
ProductInfo product=new ProductInfo();
//OrderInfo order = new OrderInfo();  
//order.CustomerName = read.GetString(0);
//order.OrderDate = read.GetDateTime(1);
product.ProductId = read.GetString(2);
product.ProductName = read.GetString(3);
product.Price = read.GetInt32(4);
product.Imagepath = read.GetString(5);
product.Count = read.GetInt32(6);
product.Description = read.GetString(7);
list.Add(product);
}
}
read.Close();
return list;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
throw ex;
}
}
就是把我注释的内容也添加到list当中去

Answer 1

ProductInfo 中增加两个字段CustomerName，OrderDate。Info中的字段不一定要和数据库一样，根据需要可以做适当扩展

Answer 2

SqlDataReader 的 NextResult()，然后用同一个 reader 再 Read()