IsDeleted?

How do you make use of a IsDeleted column?   I have a users table, but the user.delete function throws an exception "Invalid syntax near" User.  I think that may be due to that being a keyword, but without the IsDeleted column, the .Delete method works.  Please help explain what needs to be done to allow SubSonic set that flag and the query only pull "Non-Deleted" users.  I have found no documentation on this.

Thanks...

This should be a non null - bit column

And you use it like this

User user = new User(1);
user.Delete();

UserCollection userColl = new UserCollection().Where(User.Column.IsDeleted, false).Load();

yitzchok:

Where(User.Column.IsDeleted, false)

In 2.1 you don't even need this part

Good one I didn't know about it.

Thanks

I was under the impression that some additional logic would be created by SubSonic to mark the record deleted and not delete.  Is this the case?  I hadn't had a chance to give that a shot yet as I was getting an incorrect syntax error.

That's right. If you're table has a column named "Deleted" or "IsDeleted", subsonic will set the value of that column to true instead of physically deleting the record. If this is the case and you really need to physically delete the row, you can call a Destroy() method.

In a one to many relation I use the deleted column as a flag for deleted "many" items.

When the user saves his changes I destroy every Deleted Column before calling MyTableCollection.SaveAll()

You Can also do something like this:
mytablecollection col = new mytablecollection().Load();  //loads all elements of the table
col.Remove( col[0] );  // Remove first item of the collection
col.ProcessDeletedItems(); // Calls Delete for every removed Item

Note: ProcessDeletedItems is, unlike SaveAll(), not in the scope of an transaction.

By the way: It would be nice to have the deleted or isdeleted column added to the table with
Migrations: AddSubSonicStateColumns(TableObject);
like the created and modified ones.