public override SQLiteDataReader ExecuteDataReader(SQLiteParam procParam) { Stopwatch _stopwatch = null; SQLiteDataReader reader = null; try { //this.executionStartTime = DateTime.Now; _stopwatch = new Stopwatch(); _stopwatch.Start(); reader = base._getReader(procParam); _stopwatch.Stop(); //this.executionStopTime = DateTime.Now; } catch (Exception ex) { base.lastException = ex; throw ex; } finally { //base.ExecuteTime = this.executionStopTime - this.executionStartTime; _stopwatch = null; } return(reader); }
protected SQLiteDataReader _getReader(SQLiteParam param) { if (this.Connection == null) { return(null); } SQLiteCommand ret = new SQLiteCommand(); ret.CommandType = CommandType.Text; ret.CommandText = param.CommandText; ret.Connection = this.Connection; ret.CommandTimeout = 0; if (this.IsTransactionActive) { if (this.currentTransaction != null) { ret.Transaction = this.currentTransaction; } else { throw new MSDataLayerException("Cannot assign null transaction to command."); } } if (param.Parameters != null) { this.SetParaMeterToCommand(ref ret, param.Parameters); } return(ret.ExecuteReader()); }
public override object ExecuteScalar(SQLiteParam procParam) { Stopwatch _stopwatch = null; SQLiteCommand cmd = null; object objScalar = null; try { //this.executionStartTime = DateTime.Now; _stopwatch = new Stopwatch(); base.BeginTransaction(); cmd = base._getCommand(procParam); if (cmd != null) { _stopwatch.Start(); objScalar = cmd.ExecuteScalar(); _stopwatch.Stop(); } else { throw new MSDataLayerException("Command cannot be created since connection is not initialized."); } this.lastException = null; base.CommitTransaction(); //this.executionStopTime = DateTime.Now; } catch (MSDataLayerException tEx) { base.RollbackTransaction(); objScalar = null; throw tEx; } catch (Exception ex) { base.RollbackTransaction(); objScalar = null; this.lastException = ex; } finally { //base.ExecuteTime = this.executionStopTime - this.executionStartTime; _stopwatch = null; cmd.Dispose(); cmd = null; } return(objScalar); throw new NotImplementedException(); }
public override int ExecuteNonQuery(SQLiteParam procParam) { Stopwatch _stopwatch = null; SQLiteCommand cmd = null; int ret = 0; try { //this.executionStartTime = DateTime.Now; _stopwatch = new Stopwatch(); base.BeginTransaction(); cmd = base._getCommand(procParam); if (cmd != null) { _stopwatch.Start(); ret = cmd.ExecuteNonQuery(); _stopwatch.Stop(); } else { throw new MSDataLayerException("Command cannot be created since connection is not initialized."); } this.lastException = null; base.CommitTransaction(); //this.executionStopTime = DateTime.Now; } catch (MSDataLayerException tEx) { base.RollbackTransaction(); throw tEx; } catch (Exception ex) { base.RollbackTransaction(); ret = SQLiteDataAccess.ERROR_RESULT; this.lastException = ex; } finally { //base.ExecuteTime = this.executionStopTime - this.executionStartTime; _stopwatch = null; cmd.Dispose(); cmd = null; } return(ret); }
public override DataTable GetDataTable(SQLiteParam procParam, string tableName) { Stopwatch _stopwatch = null; SQLiteCommand cmd = null; SQLiteDataAdapter dap = null; DataTable dtb = new DataTable(tableName); try { //this.executionStartTime = DateTime.Now; _stopwatch = new Stopwatch(); dtb.BeginLoadData(); _stopwatch.Start(); cmd = base._getCommand(procParam); dap = new SQLiteDataAdapter(cmd); dap.Fill(dtb); _stopwatch.Stop(); dtb.EndLoadData(); //this.executionStopTime = DateTime.Now; } catch (Exception ex) { base.lastException = ex; throw ex; } finally { //base.ExecuteTime = this.executionStopTime - this.executionStartTime; _stopwatch = null; cmd.Dispose(); cmd = null; dap.Dispose(); dap = null; } return(dtb); }
public abstract SQLiteDataReader ExecuteDataReader(SQLiteParam procParam);
public abstract object ExecuteScalar(SQLiteParam procParam);
public abstract int ExecuteNonQuery(SQLiteParam procParam);
public abstract DataTable GetDataTable(SQLiteParam procParam, string tableName);
public abstract DataTable GetDataTable(SQLiteParam procParam);