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

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