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;
}
