public static List <List <string> > ExecuteReader(this string sql, string connStr, ClientType type = ClientType.SqlSever) { var result = new List <List <string> >(); switch (type) { case ClientType.SqlSever: { result = DbUtility.ExecuteReaderForSqlSever(sql, connStr); } break; case ClientType.Oracle: { result = DbUtility.ExecuteReaderForOracle(sql, connStr); } break; case ClientType.MySql: { throw new NotImplementedException(); } } return(result); }
//[Obsolete("请使用ExecuteReader2代替")] //public static SqlDataReader ExecuteReader(this string sql, string connStr) //{ // throw new Exception("方法已废弃,请使用ExecuteReader2代替!"); // SqlDataReader reader; // var Con = new SqlConnection(connStr); // var Com = new SqlCommand(sql, Con); // try // { // Con.Open(); // reader = Com.ExecuteReader(); // } // catch (Exception ex) // { // throw ex; // } // return reader; //} public static List <List <string> > ExecuteReader2(this string sql, string connStr) { return(DbUtility.ExecuteReaderForSqlSever(sql, connStr)); }