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

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