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

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