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