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

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