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

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