public void ExecuteNonQuery(string command) { try { using (var orclDbManager = new OrclDBManager()) { using (var orclTranManager = new OrclTranManager(orclDbManager, OrclTranOption.None)) { try { orclTranManager.CommandType = CommandType.Text; orclTranManager.CommandText = command; orclTranManager.ExecuteNonQuery(); } catch (Exception) { throw; } } } } catch (Exception) { throw; } }
public DataTable GetDatatable(string command) { DataSet dataSet; try { using (var orclDbManager = new OrclDBManager()) { using (var orclTranManager = new OrclTranManager(orclDbManager, OrclTranOption.None)) { try { orclTranManager.CommandType = CommandType.Text; orclTranManager.CommandText = command; dataSet = orclTranManager.GetData(); } catch (Exception) { throw; } } } } catch (Exception ex) { throw; } if (dataSet.Tables.Count == 0) { return new DataTable(); } return dataSet.Tables[0]; }
public OrclTranManager(OrclDBManager dBManager, OrclTranOption tranOption) { _dBManager = dBManager; _tranOption = tranOption; _orclCommand = new OracleCommand(); _orclCommand.Connection = _dBManager.Connection; switch (_tranOption) { case OrclTranOption.Require: _orclTransaction = _dBManager.Connection.BeginTransaction(); _orclCommand.Transaction = _orclTransaction; break; default: break; } }