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

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