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

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