DataSet to List

DataSet의 데이터를 List형태로 변환 하는 방법.

public List GetAllProducts(string sqlQuery) {
    DataSet dsinsert = GetDataSet(sqlQuery, "tblProducts");

    return (from row in dsinsert.Tables[0].AsEnumerable()
            select new ProductsDAL {
                Product_ID = row.Field("Product_ID"),
                ProductDescr = row.Field("ProductDescr"),
            }).ToList();
}