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

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