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

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