public void ConfigureCommand(NpgsqlCommand command)
{
var sql = _selector.ToSelectClause(null);
var param = command.AddParameter(_id);
sql += " where id = :" + param.ParameterName;
command.AppendQuery(sql);
}
public override void ConfigureCommand(NpgsqlCommand command)
{
var sql = _selector.ToSelectClause(null);
var param = command.AddParameter(_streamId);
sql += $" where stream_id = :{param.ParameterName}";
if (_version > 0)
{
var versionParam = command.AddParameter(_version);
sql += " and version <= :" + versionParam.ParameterName;
}
if (_timestamp.HasValue)
{
var timestampParam = command.AddParameter(_timestamp.Value);
sql += " and timestamp <= :" + timestampParam.ParameterName;
}
sql += " order by version";
command.AppendQuery(sql);
}
