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

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