http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : how to delete an row in database? Tue, 28 Apr 2026 05:01:20 -700 Wed, 08 Apr 2009 12:21:18 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1181 http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ http://www.ideablade.com/forum/forum_posts.asp?TID=1181&PID=4351#4351 Author: rclarke
Subject: 1181
Posted: 08-Apr-2009 at 12:21pm

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.]]> Wed, 08 Apr 2009 12:21:18 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1181&PID=4351#4351 http://www.ideablade.com/forum/forum_posts.asp?TID=1181&PID=4349#4349 Author: davidklitzke
Subject: 1181
Posted: 08-Apr-2009 at 11:28am

In most cases, you will just know how to access the other table.  If you know about Orders, you will just know about OrderDetails.  I am not trying to solve the general problem of deletion failing becauser of some unkown foreign key.]]> Wed, 08 Apr 2009 11:28:43 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1181&PID=4349#4349 http://www.ideablade.com/forum/forum_posts.asp?TID=1181&PID=4347#4347 Author: monkeyking
Subject: 1181
Posted: 07-Apr-2009 at 6:55pm

thx David, how can i refer to other table with a devforce entity?]]> Tue, 07 Apr 2009 18:55:43 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1181&PID=4347#4347 http://www.ideablade.com/forum/forum_posts.asp?TID=1181&PID=4333#4333 Author: davidklitzke
Subject: 1181
Posted: 06-Apr-2009 at 9:58pm

You are correct.  You cannot delete a row that has a relationship to another row.  For example, you cannot delete an Order that has a bunch of OrderDetails.  To delete the Order, delete all of the OrderDetails.  Then delete the Order.]]> Mon, 06 Apr 2009 21:58:33 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1181&PID=4333#4333 http://www.ideablade.com/forum/forum_posts.asp?TID=1181&PID=4312#4312 Author: monkeyking
Subject: 1181
Posted: 05-Apr-2009 at 11:58pm

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?



]]> Sun, 05 Apr 2009 23:58:22 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1181&PID=4312#4312 http://www.ideablade.com/forum/forum_posts.asp?TID=1181&PID=4234#4234 Author: jeffdoolittle
Subject: 1181
Posted: 01-Apr-2009 at 12:09pm

In DevForce Classic, you can call myEntity.Delete() directly on an Entity.  In DevForce EF, you call myEntity.EntityAspect.Delete().


--Jeff
]]> Wed, 01 Apr 2009 12:09:24 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1181&PID=4234#4234 http://www.ideablade.com/forum/forum_posts.asp?TID=1181&PID=4233#4233 Author: monkeyking
Subject: 1181
Posted: 31-Mar-2009 at 11:38pm

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.]]> Tue, 31 Mar 2009 23:38:57 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1181&PID=4233#4233 http://www.ideablade.com/forum/forum_posts.asp?TID=1181&PID=4232#4232 Author: jeffdoolittle
Subject: 1181
Posted: 31-Mar-2009 at 10:09pm

Removing an entity simply detaches it from the entity manager, leaving no pending changes to submit to the database.  Instead, you need to call Delete on the entity itself and then save the changes in the entity manager that is managing that entity.

--Jeff
]]> Tue, 31 Mar 2009 22:09:25 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1181&PID=4232#4232 http://www.ideablade.com/forum/forum_posts.asp?TID=1181&PID=4231#4231 Author: monkeyking
Subject: 1181
Posted: 31-Mar-2009 at 7:47pm

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
]]> Tue, 31 Mar 2009 19:47:50 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1181&PID=4231#4231