public DbCommand DeleteMany(string persistenceId, long maxSequenceNr, DateTime maxTimestamp)
{
var sqlCommand = new SQLiteCommand();
sqlCommand.Parameters.Add(new SQLiteParameter { Value = persistenceId });
var sb = new StringBuilder(_deleteSql);
if (maxSequenceNr < long.MaxValue && maxSequenceNr > 0)
{
sb.Append(@" AND sequence_nr <= ").Append(maxSequenceNr);
}
if (maxTimestamp > DateTime.MinValue && maxTimestamp < DateTime.MaxValue)
{
sb.AppendFormat(@" AND created_at <= {0}", maxTimestamp.Ticks);
}
sqlCommand.CommandText = sb.ToString();
return sqlCommand;
}