how to delete an row in database?

can any one please tell which section of the developer guide can teach insert, delete, update the database? i have no problem with insert and update, but i can't delete the row from database after i insert it.

for example, i create a new row, assign values on it and insert it into the cache, save it. it works fine, database be able to be changed. but once i add a line of code "manager.loginUsers.EntityManager.RemoveEntyt(auser);" to delete that row, database doesn't have any changes.




am i on the right track to insert a row? and how can i delete a row? which section introduce these techniques

Regards
John

each entity doesn't have a delete method to destroy itself. I used EntityManager.RemoveEntity(Entity), but it didn't work. see the second last line of code in the picture.

thx Jeff

that works :-) I have another problem, where is here.


it think because that row refer to other table, so i couldn't delete it. but i can delete it if that table doesn't contain any forein key. so my question is, how can i deal with this issue?

thx David, how can i refer to other table with a devforce entity?

If your are using SQL Server and you have control of the database design you might want to look into setting cascading deletes on the relationship definition in SQL Server. This way when you delete a row like an order item, SQL Server will delete the order details as well as the order item. This reduces the risk of orphaned rows but may not be the behavior you want in all cases.