SimpleDB softDelete permanently delete?

Hi,

I am trying to permanently delete entities from SimpleDB using lightspeed softDelete:

----------------------------------------------------------------

             var query = new Query(typeof(T))
            {
                QueryExpression = Entity.Attribute("DeletedOn") < DateTime.UtcNow.AddDays(-1),
                IncludeDeleted = true
            };

            data.Remove(query);
            data.SaveChanges();

----------------------------------------------------------------

This does not seem to work, it just re-updates the record with a new DeletedOn timestamp

How to permanently delete softDeleted records in SimpleDB using lightspeed?

Thanks,

-Joe

LightSpeed doesn't currently provide a method for purging soft-deleted objects.  My view is that purging is an operational matter that would be handled by a DBA, not something that the application should be doing, but I know some of the other guys disagree -- and of course my argument doesn't make sense for an environment like SimpleDB that doesn't have the kind of monitoring / admin / scripting tools that RDBMSes have.  So this is probably something we'll have to reconsider in the near future.

In the meantime, you'd need to use a separate admin tool such as SimpleDB Management Tools, or write a tool that calls down to the underlying SimpleDB library (e.g. so you can script it or run it as a scheduled task).  Happy to provide guidance on the latter if required.

Thanks Ivan, that makes sense... it would be nice to be able to execute SimpleDB commands directly through lightspeed, but that is not really the role of an ORM.  So we will just pull down the SimpleDB c# library and roll out our own simple command execution through that.

It has been nice that we have used Lightspeed for all DB access until now, but I figured it had to happen sooner or later where we need to call SimpleDB directly....

Thanks for your great support!

-Joe