Csharp: The difference between ODP. NET and System. Data. OracleClient (. net 4.0) Reading Oracle g 11.2.0, csharpodp.net
ODP. NET:
Reference:
Using Oracle. DataAccess; // Oracle g 11.2.0using Oracle. DataAccess. Client; using Oracle. DataAccess. Types; // download catalog //. net 4.0 // https://docs.oracle.com/cd/B19306_01/server.102/b14220/schema.htm
/// <Summary> // 20160918 tu juwen // Geovin Du /// </summary> public class BookKindListDAL: IBookKindList {// <summary> /// append record /// </summary> /// <param name = "BookKindListInfo"> </param> /// <returns> </returns> public int InsertBookKindList (BookKindListInfo bookKindList) {int ret = 0; try {OracleParameter [] par = new OracleParameter [] {new OracleParameter ("temTypeName", OracleDbType. NVarchar2, 1000), n Ew OracleParameter ("temParent", OracleDbType. int32, 4),}; par [0]. value = bookKindList. bookKindName; par [1]. value = bookKindList. bookKindParent; ret = OracleHelper. executeSql ("proc_Insert_BookKindList", CommandType. storedProcedure, par);} catch (OracleException ex) {throw ex;} return ret ;} /// <summary> /// return the append record /// </summary> /// <param name = "authorList"> </param> /// <param name = "authorID"> </p Aram> // <returns> </returns> public int InsertBookKindOutput (BookKindListInfo bookKindList, out int bookKindLID) {bookKindLID = 0; int ret = 0; try {OracleParameter [] par = new OracleParameter [] {new OracleParameter ("temTypeName", OracleDbType. NVarchar2, 1000), new OracleParameter ("temParent", OracleDbType. int32, 4), new OracleParameter ("temId", OracleDbType. int32, 4),}; par [0]. value = bookKindList. bo OkKindName; par [1]. value = bookKindList. bookKindParent; par [2]. direction = ParameterDirection. output; ret = OracleHelper. executeSql ("proc_Insert_BookKindOut", CommandType. storedProcedure, par); if (ret> 0) {bookKindLID = int. parse (par [2]. value. toString () ;}} catch (OracleException ex) {throw ex;} return ret ;} /// <summary> /// modify record /// </summary> /// <param name = "BookKindListInfo"> </param> // <r Eturns> </returns> public int UpdateBookKindList (BookKindListInfo bookKindList) {int ret = 0; try {OracleParameter [] par = new OracleParameter [] {new OracleParameter ("BookKindID", OracleDbType. int32, 4), new OracleParameter ("BookKindName", OracleDbType. NVarchar2, 1000), new OracleParameter ("BookKindParent", OracleDbType. int32, 4),}; par [0]. value = bookKindList. bookKindID; par [1]. value = bookKindList. bookK IndName; par [2]. value = bookKindList. bookKindParent; ret = OracleHelper. executeSql ("proc_Update_BookKindList", CommandType. storedProcedure, par);} catch (OracleException ex) {throw ex;} return ret ;} /// <summary> /// Delete record /// </summary> /// <param name = "bookKindIDInfo"> </param> /// <returns> </returns> public bool DeleteBookKindList (int bookKindID) {bool ret = false; try {OracleParameter par = ne W OracleParameter ("BookKindID", bookKindID); int temp = 0; temp = OracleHelper. ExecuteSql ("proc_Delete_BookKindList", CommandType. StoredProcedure, par); if (temp! = 0) {ret = true;} catch (OracleException ex) {throw ex;} return ret ;} /// <summary> /// query records /// </summary> /// <param name = "bookKindIDInfo"> </param> /// <returns> </returns> public BookKindListInfo SelectBookKindList (int bookKindID) {BookKindListInfo bookKindList = null; try {OracleParameter par = new OracleParameter ("BookKindID", bookKindID); using (OracleDataReader reader = OracleHelper. get Reader ("proc_Select_BookKindList", CommandType. StoredProcedure, par) {if (reader. Read () {bookKindList = new BookKindListInfo (); bookKindList. BookKindID = (! Object. Equals (reader ["BookKindID"], null ))? (Int) reader ["BookKindID"]: 0; bookKindList. BookKindName = (! Object. Equals (reader ["BookKindName"], null ))? (String) reader ["BookKindName"]: ""; bookKindList. BookKindParent = (! Object. Equals (reader ["BookKindParent"], null ))? (Int) reader ["BookKindParent"]: 0 ;}} catch (OracleException ex) {throw ex;} return bookKindList ;} /// <summary> /// query all records /// </summary> /// <returns> </returns> public List <BookKindListInfo> SelectBookKindListAll () {List <BookKindListInfo> list = new List <BookKindListInfo> (); BookKindListInfo bookKindList = null; try {using (OracleDataReader reader = OracleHelper. getReader ("proc_Select_BookK IndListAll ", CommandType. StoredProcedure, null) {while (reader. Read () {bookKindList = new BookKindListInfo (); bookKindList. BookKindID = (! Object. Equals (reader ["BookKindID"], null ))? (Int) reader ["BookKindID"]: 0; bookKindList. BookKindName = (! Object. Equals (reader ["BookKindName"], null ))? (String) reader ["BookKindName"]: ""; bookKindList. BookKindParent = (! Object. Equals (reader ["BookKindParent"], null ))? (Int) reader ["BookKindParent"]: 0; list. add (bookKindList) ;}} catch (OracleException ex) {throw ex;} return list ;} /// <summary> /// query all records /// </summary> /// <returns> </returns> public DataTable SelectBookKindListDataTableAll () {DataTable dt = new DataTable (); try {using (DataTable reader = OracleHelper. getTable ("proc_Select_BookKindListAll", CommandType. storedProcedure, null) {dt = reader ;}} catch (OracleException ex) {throw ex;} return dt ;}}
System. Data. OracleClient (. net 4.0)
Reference:
Using System. collections; using System. data; using System. configuration; using System. data. oracleClient ;//. net 4.0 // reference // https://msdn.microsoft.com/en-us/library/system.data.oracleclient.oracledataadapter (v = vs.110 ). aspx // http://blog.csdn.net/chinawn/article/details/33664//c:#program Files \ Reference Assemblies \ Microsoft \ Framework \. NETFramework \ v4.0 \ System. data. oracleClient. dll
/// <Summary> // 20160918 tu juwen // Geovin Du /// </summary> public class BookKindListDAL: IBookKindList {// <summary> /// append record /// </summary> /// <param name = "BookKindListInfo"> </param> /// <returns> </returns> public int InsertBookKindList (BookKindListInfo bookKindList) {int ret = 0; try {OracleParameter [] par = new OracleParameter [] {new OracleParameter ("temTypeName", OracleType. NVarChar, 1000), new OracleParameter ("temParent", OracleType. number, 4),}; par [0]. value = bookKindList. bookKindName; par [1]. value = bookKindList. bookKindParent; ret = OracleHelper. executeSql ("proc_Insert_BookKindList", CommandType. storedProcedure, par);} catch (OracleException ex) {throw ex;} return ret ;} /// <summary> /// return the append record /// </summary> /// <param name = "authorList"> </param> /// <param name = "authorID"> </param >/// <Returns> </returns> public int InsertBookKindOutput (BookKindListInfo bookKindList, out int bookKindLID) {bookKindLID = 0; int ret = 0; try {OracleParameter [] par = new OracleParameter [] {new OracleParameter ("temTypeName", OracleType. NVarChar, 1000), new OracleParameter ("temParent", OracleType. number, 4), new OracleParameter ("temId", OracleType. number, 4),}; par [0]. value = bookKindList. bookkindna m E; par [1]. value = bookKindList. bookKindParent; par [2]. direction = ParameterDirection. output; ret = OracleHelper. executeSql ("proc_Insert_BookKindOut", CommandType. storedProcedure, par); if (ret> 0) {bookKindLID = int. parse (par [2]. value. toString () ;}} catch (OracleException ex) {throw ex;} return ret ;} /// <summary> /// modify record /// </summary> /// <param name = "BookKindListInfo"> </param> /// <returns> </ Returns> public int UpdateBookKindList (BookKindListInfo bookKindList) {int ret = 0; try {OracleParameter [] par = new OracleParameter [] {new OracleParameter ("BookKindID", OracleType. number, 4), new OracleParameter ("BookKindName", OracleType. NVarChar, 1000), new OracleParameter ("BookKindParent", OracleType. number, 4),}; par [0]. value = bookKindList. bookKindID; par [1]. value = bookKindList. bookKindName; par [2 ]. Value = bookKindList. bookKindParent; ret = OracleHelper. executeSql ("proc_Update_BookKindList", CommandType. storedProcedure, par);} catch (OracleException ex) {throw ex;} return ret ;} /// <summary> /// Delete record /// </summary> /// <param name = "bookKindIDInfo"> </param> /// <returns> </returns> public bool DeleteBookKindList (int bookKindID) {bool ret = false; try {OracleParameter par = new OracleParame Ter ("BookKindID", bookKindID); int temp = 0; temp = OracleHelper. ExecuteSql ("proc_Delete_BookKindList", CommandType. StoredProcedure, par); if (temp! = 0) {ret = true;} catch (OracleException ex) {throw ex;} return ret ;} /// <summary> /// query records /// </summary> /// <param name = "bookKindIDInfo"> </param> /// <returns> </returns> public BookKindListInfo SelectBookKindList (int bookKindID) {BookKindListInfo bookKindList = null; try {OracleParameter par = new OracleParameter ("BookKindID", bookKindID); using (OracleDataReader reader = OracleHelper. get Reader ("proc_Select_BookKindList", CommandType. StoredProcedure, par) {if (reader. Read () {bookKindList = new BookKindListInfo (); bookKindList. BookKindID = (! Object. Equals (reader ["BookKindID"], null ))? (Int) reader ["BookKindID"]: 0; bookKindList. BookKindName = (! Object. Equals (reader ["BookKindName"], null ))? (String) reader ["BookKindName"]: ""; bookKindList. BookKindParent = (! Object. Equals (reader ["BookKindParent"], null ))? (Int) reader ["BookKindParent"]: 0 ;}} catch (OracleException ex) {throw ex;} return bookKindList ;} /// <summary> /// query all records /// </summary> /// <returns> </returns> public List <BookKindListInfo> SelectBookKindListAll () {List <BookKindListInfo> list = new List <BookKindListInfo> (); BookKindListInfo bookKindList = null; try {using (OracleDataReader reader = OracleHelper. getReader ("proc_Select_BookK IndListAll ", CommandType. StoredProcedure, null) {while (reader. Read () {bookKindList = new BookKindListInfo (); bookKindList. BookKindID = (! Object. Equals (reader ["BookKindID"], null ))? (Int) reader ["BookKindID"]: 0; bookKindList. BookKindName = (! Object. Equals (reader ["BookKindName"], null ))? (String) reader ["BookKindName"]: ""; bookKindList. BookKindParent = (! Object. Equals (reader ["BookKindParent"], null ))? (Int) reader ["BookKindParent"]: 0; list. add (bookKindList) ;}} catch (OracleException ex) {throw ex;} return list ;} /// <summary> /// query all records /// </summary> /// <returns> </returns> public DataTable SelectBookKindListDataTableAll () {DataTable dt = new DataTable (); try {using (DataTable reader = OracleHelper. getTable ("proc_Select_BookKindListAll", CommandType. storedProcedure, null) {dt = reader ;}} catch (OracleException ex) {throw ex;} return dt ;}}