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

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