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

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