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

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