public DbCommand SelectEvents(IEnumerable<IHint> hints)
{
var sqlCommand = new SQLiteCommand();
var sqlized = hints
.Select(h => HintToSql(h, sqlCommand))
.Where(x => !string.IsNullOrEmpty(x));
var where = string.Join(" AND ", sqlized);
var sql = new StringBuilder("SELECT persistence_id, sequence_nr, is_deleted, manifest, payload FROM " + _tableName);
if (!string.IsNullOrEmpty(where))
{
sql.Append(" WHERE ").Append(where);
}
sqlCommand.CommandText = sql.ToString();
return sqlCommand;
}