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

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