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

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