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

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