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

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