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

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