InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumTue, 09 Jun 2026 17:47:46 GMT20http://forum.strataframe.net/FindPost6928.aspxHi,</P><P>I have temporary BO to allow user to edit records which is in un-normalized format. Then, I want to add these records back to normalized table - ParentTable and ChildTable.</P><P>After saved,User may&nbsp;want retrieve and edit/delete records in this temporary BO. Any simple way to "merge" back the records to database? Does BusinessLayer.MergeDataTable() do what I need?</P><P>Thank youMon, 19 Feb 2007 09:11:06 GMTChanhttp://forum.strataframe.net/FindPost6937.aspxThe only way to automatically do what you're talking about is to create an updatable view (either an indexed view that can be updated, or stored procedures to update, insert and delete records from the view) and build a business object from that view.&nbsp; Then, you can add new records to the business object and save them.&nbsp; Otherwise, you'll have to hand-code the transfer of the data back into the separate child &amp; parent business objects.&nbsp;</P><P>The MergeDataTable() method is used to merge two separate data tables that have the same structure down to one DataTable, removing conflicting records by testing the PK values.Mon, 19 Feb 2007 09:11:06 GMTStrataFrame Team