Tech Articles


Tracking Actions with SqlModelMapper


This document will describe how to track actions with SqlModelMapper. SqlModelMapper enables you to track database table operations, as well as actions which encapsulate customized methods. These actions will be called when the SaveChanges() method of the SqlModelMapper is called. This enables you to perform several different tasks and operations on the data before the transaction is committed.

To view the full content of the document, see: https://www.appeon.com/support/documents/appeon_online_help/snapobjects/Tracking_Actions_in_SqlModelMapper/index.html. 

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.

Working with Transactions in SnapObjects


This document will describe using transactions in SnapObjects. SnapObjects provides SqlModelMapper and SqlExecutor objects for performing CRUD operations to the database. All those objects explicitly and/or implicitly use DataContext's transaction APIs to manage transactions.

To view the full content of the document, see: https://www.appeon.com/support/documents/appeon_online_help/snapobjects/Working_with_Transactions_in_SnapObjects/index.html. 

Add Data Validation to SqlModelMapper


This tutorial explains the basics of adding and performing data validation with SqlModelMapper using SnapDevelop. It provides you an example on how to integrate the data validation to your CRUD operations.

In this tutorial you will learn:

  • What is data validation in SqlModelMapper
  • How to add data validation to your models
  • How to perform validation against tracked models

To view the full content of the tutorial, see: https://www.appeon.com/support/documents/appeon_online_help/snapobjects/Add_Data_Validation_to_SqlModelMapper/index.html. 

CRUD Operations with SqlModelMapper


This tutorial demonstrates the basics of creating, in SnapDevelop, a Web API with ASP.NET Core that will use SqlModelMapper as its data manipulation component.

In this tutorial, you will learn to:

  • Create a Web API Project
  • Test the API
  • Add a Database Context
  • Register the Database Context
  • Add a SqlModelMapper Model
  • Add a Service
  • Perform CRUD Operations Using the Web API
  • Call the Web API from PowerBuilder

To view the full content of the tutorial, see: https://www.appeon.com/support/documents/appeon_online_help/snapobjects/CRUD_Operations_with_SqlModelMapper/index.html.

Find Articles by Tag

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