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

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