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

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