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

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