public SqlDataReaderLRAP ExecuteReader(CommandBehavior behavior = CommandBehavior.Default) { var reqResult = LoggingDB.LogRequest(this, LoggingDBType.CmdReader, behavior); var cmdDto = reqResult.Object as SqlCommandDTO; return(new SqlDataReaderLRAP(cmdDto, Cmd.ExecuteReader(behavior))); }
public async Task <SqlDataReaderLRAP> ExecuteReaderAsync(CommandBehavior behavior = CommandBehavior.Default) { var reqResult = LoggingDB.LogRequest(this, LoggingDBType.CmdReader, behavior); var cmdDto = reqResult.Object as SqlCommandDTO; var result = await Cmd.ExecuteReaderAsync(behavior); return(new SqlDataReaderLRAP(cmdDto, result)); }
public async Task <int> ExecuteNonQueryAsync() { var reqResult = LoggingDB.LogRequest(this, LoggingDBType.CmdNonQuery); var cmdDto = reqResult.Object as SqlCommandDTO; var cmdResult = await Cmd.ExecuteNonQueryAsync(); LoggingDB.LogResponse(cmdDto, cmdResult); return(cmdResult); }
public object ExecuteScalar() { var reqResult = LoggingDB.LogRequest(this, LoggingDBType.CmdScalar); var cmdDto = reqResult.Object as SqlCommandDTO; var cmdResult = Cmd.ExecuteScalar(); LoggingDB.LogResponse(cmdDto, cmdResult); return(cmdResult); }
public int ExecuteNonQuery() { var reqResult = LoggingDB.LogRequest(this, LoggingDBType.CmdNonQuery); var cmdDto = reqResult.Object as SqlCommandDTO; var cmdResult = Cmd.ExecuteNonQuery(); LoggingDB.LogResponse(cmdDto, cmdResult); return(cmdResult); }
public bool Read() { var result = Reader.Read(); if (CurrentReaderResultDTO == null) { CurrentReaderResultDTO = LoggingDB.MapReaderToReaderResultDTO(Reader, CurrentResultIndex); } if (result) { var readerRow = LoggingDB.MapReaderToReaderRow(Reader); CurrentReaderResultDTO.Rows.Add(readerRow); } return(result); }
private void DoLogging() { LoggingDB.LogResponse(CommandDTO, CurrentReaderResultDTO); CurrentReaderResultDTO = null; }