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

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