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