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

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