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