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

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