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

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