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