string ConnectionString = ConfigurationManager.ConnectionStrings["OracleConstr"].ConnectionString; ; //写连接串
OracleConnection conn = new OracleConnection(ConnectionString); //创建一个新连接
OracleCommand cmd = new OracleCommand(sql, conn);
DataSet ds = new DataSet();
OracleDataAdapter oda = new OracleDataAdapter();
oda.SelectCommand = cmd;
oda.Fill(ds);
var result=DataSetToList<Tentity>(ds, 0); //调用转换函数
/// <summary>
/// DataSetToList
/// </summary>
/// <typeparam name="Tentity">转换类型</typeparam>
/// <param name="ds">一个DataSet实例,也就是数据源</param>
/// <param name="tableIndext">DataSet容器里table的下标,只有用于取得哪个table,也就是需要转换表的索引</param>
/// <returns></returns>
public static List<Tentity>