public SqlItemResultDataReader(IDbConnection connection, string sqlQuery, SearchParameter searchParameter)
{
_command = connection.CreateCommand();
_command.CommandType = CommandType.Text;
_command.CommandText = sqlQuery;
var parameter = _command.CreateParameter();
parameter.Direction = ParameterDirection.Input;
parameter.ParameterName = searchParameter.ParameterName;
parameter.DbType = DbType.String;
parameter.Value = searchParameter.ParameterValue;
_command.Parameters.Add(parameter);
EnsureConnectionOpen(connection);
_reader = _command.ExecuteReader();
_idColumnIndex = _reader.GetOrdinal("Id");
_weightColumnIndex = _reader.GetOrdinal("Weight");
}
public ISqlItemResultDataReader Create(string sqlQuery, SearchParameter searchParameter)
{
return(new SqlItemResultDataReader(_connection, sqlQuery, searchParameter));
}