Tech Articles


Using Nested Models in SqlModelMapper (multi level cascading for dependent models)


This document describes how to use Nested Models with SqlModelMapper. SnapObjects provides an object (SqlModelMapper) that simplifies the usage of nested models in multiple cascading dependent levels. SnapObjects provides APIs to manage the operations performed on these nested models.

Nested Models can represent complex relationships, such as Master-Detail-Detail. The Master-Detail relationship can be of cardinality types: one-to-one and one-to-many. The Master-Detail-Detail relationship can be of cardinality types: one-to-one-to-one and one-to-one-to-many. However, under certain circumstances, you can also manage N-Level relationships for single SQL Insert, Update or Delete operations.

To view the full content of the document, see: https://www.appeon.com/support/documents/appeon_online_help/snapobjects/Using_Nested_Models_in_SqlModelMapper/index.html.

Comments (0)
There are no comments posted here yet

Find Articles by Tag

Icon DLL SVN Database Connection Resize PowerScript (PS) OAuth 2.0 SnapObjects CoderObject OAuth License UI COM GhostScript Debugger UI Themes Installation Database Table SnapDevelop Encoding Variable Testing Export JSON ODBC .NET Assembly PowerBuilder Compiler Error CI/CD Bug Export Application PFC JSONGenerator OrcaScript Jenkins JSONParser Branch & Merge Git PostgreSQL File DataWindow PDF Linux OS DragDrop Validation Import iOS MessageBox Source Control Design Event CrypterObject SOAP UI Modernization DataWindow JSON Event Handler RibbonBar .NET Std Framework Filter RibbonBar Builder Azure Transaction TreeView Encryption Data Sort Class XML Platform Script Window External Functions Mobile DevOps Windows 10 Icons PowerBuilder (Appeon) PBDOM Debugging Outlook 64-bit Import JSON Text Authentication Model OLE Database Painter 32-bit PostgreSQL ODBC driver Repository PowerServer Web Graph BLOB SqlExecutor JSON C# Interface ActiveX Database Table Data Excel Trial RichTextEdit Control API Android Configuration Web Service Proxy Open Source HTTPClient NativePDF Web API TortoiseGit InfoMaker Oracle PowerServer Mobile Charts Performance REST Expression Source Code Debug SQL Server Event Handling Elevate Conference Authorization Database Table Schema TFS DataType Menu SQL .NET DataStore SqlModelMapper Syntax Messagging PowerBuilder PDFlib Database Object Stored Procedure RESTClient Database Profile Migration Automated Testing IDE Array Windows OS Service TLS/SSL Database WinAPI WebBrowser SDK Deployment