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

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