public DbCommand DeleteBatchMessages(string persistenceId, long toSequenceNr)
{
var sb = new StringBuilder();
sb.Append("DELETE FROM ").Append(_tableName);
sb.Append(" WHERE persistence_id = ?");
if (toSequenceNr != long.MaxValue)
{
sb.Append(" AND sequence_nr <= ").Append(toSequenceNr);
}
return new SQLiteCommand(sb.ToString())
{
Parameters = { new SQLiteParameter { Value = persistenceId } }
};
}
}