{"id":7353,"date":"2004-08-30T17:10:00","date_gmt":"2004-08-30T17:10:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/vbteam\/2004\/08\/30\/transactional-update-using-tableadapters\/"},"modified":"2024-07-05T14:58:50","modified_gmt":"2024-07-05T21:58:50","slug":"transactional-update-using-tableadapters","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/vbteam\/transactional-update-using-tableadapters\/","title":{"rendered":"Transactional Update using TableAdapters"},"content":{"rendered":"

As promised, I’ve put together a sample that demonstrates how to create a transactional update using the new Whidbey TableAdapters.<\/span> <\/p>\n

<\/font>http:\/\/windowsforms.net\/samples\/ThreeLevelUpdate.zip<\/font><\/u><\/a><\/p>\n

<\/span><\/p>\n

In this sample I create a Parent, Child and Grandchild relationship.  <\/span>The tables are named, Parent, Child and Grandchild… <\/span>J<\/span><\/span><\/p>\n

<\/span><\/p>\n

Using the sample you can see the differences between single table updates and a transactional update.<\/p>\n

<\/span><\/p>\n

The single table update will commit each table individually and can get you in a partial state.  <\/span>  <\/span>If you delete a row in the Parent table, then delete a row in the child and grandchild table, then use the Simple Update, the update will fail.  <\/span>I did not implement cascading updates in the database.  <\/span>So, deleting a parent where children still exist is a relational no-no.   <\/span><\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

If you update the three tables with the “Smart Update” I use transaction and delete the rows before deleting the parents.  <\/span>Life is good.<\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

Now I must fully acknowledge that this should be the out-of-the-box behavior.  <\/span>And for that I apologize.  <\/span>We did outline some ideas early on, but we ultimately didn’t get them done.<\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

I promise to explain this further as I have time.  <\/span>I’ve been promising to get this out, so I wanted to at least get the sample up for others to take a look at.  <\/span><\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

Works in Everett<\/p>\n

<\/span><\/b><\/p>\n

I should note that theirs nothing about this example that couldn’t be applied to Visual Studio 2003.  <\/span>I’m simply showing how to incorporate this work into our new TableAdapters.<\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

Steve<\/p>\n

<\/span><\/p><\/p>\n","protected":false},"excerpt":{"rendered":"

As promised, I’ve put together a sample that demonstrates how to create a transactional update using the new Whidbey TableAdapters. http:\/\/windowsforms.net\/samples\/ThreeLevelUpdate.zip In this sample I create a Parent, Child and Grandchild relationship.  The tables are named, Parent, Child and Grandchild… J Using the sample you can see the differences between single table updates and a […]<\/p>\n","protected":false},"author":260,"featured_media":8818,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[192,195],"tags":[],"class_list":["post-7353","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-featured","category-visual-basic"],"acf":[],"blog_post_summary":"

As promised, I’ve put together a sample that demonstrates how to create a transactional update using the new Whidbey TableAdapters. http:\/\/windowsforms.net\/samples\/ThreeLevelUpdate.zip In this sample I create a Parent, Child and Grandchild relationship.  The tables are named, Parent, Child and Grandchild… J Using the sample you can see the differences between single table updates and a […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts\/7353","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/users\/260"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/comments?post=7353"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts\/7353\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/media\/8818"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/media?parent=7353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/categories?post=7353"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/tags?post=7353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}