The .NET DataStore brings the productivity of PowerBuilder to C# development. It provides a pure C# implementation of the DataWindow and other commonly-used PowerBuilder features. A tool is also included to automatically convert existing DataWindows to .NET.
Easy to Learn - the .NET DataStore provides virtually the same productive approach to programming as PowerBuilder, including non-visual DataWindow APIs (, and ), data buffers, transaction management, system functions, and SQL programming.
Minimal Coding - developers can accomplish big tasks with few lines of code, and all SQL is defined in the C# POCO model of the DataStore class, which minimizes redundant code.
Model-Driven -申博体育 driven by a standard C# POCO model that contains all data-related properties and attributes. There is a strict separation of concerns and no proprietary .SRD format.
Managed Code - 100% managed code so it benefits from the full power of the Common Language Runtime (CLR), such as built-in security, faster performance, and ease of deployment.
.NET Core - compatible with the .NET Core Framework. You can deploy to either Windows or Linux OS running a variety of Web servers or even go serverless.
Open-Source - all libraries of the .NET DataStore are available in the C# source code form in addition to the compiled NuGet packages.
Any C# IDE - you can maintain your .NET projects in any C# IDE, such as Visual Studio or SnapDevelop.
C# Programming Features
申博体育The DataStore class is created based on a standard C# POCO model. It maps columns to database tables and contains the related SQL. All the DataWindow-related functions are provided as either attributes or properties of the models. For example, the following DataWindow features are supported as standard model attributes or properties:
Using , , , Table, , , , etc. in the CRUD definitions.
申博体育 Defining the presentation styles (except OLE and Crosstab).
申博体育Learn more about the
The .NET DataStore provides a set of comprehensive interfaces to allow users to easily implement non-visual DataWindow techniques and other expanded functions in C#.
DataStore APIs – 申博体育 supports almost the same non-visual , and as the PowerBuilder DataStore.
DataWindow Expressions – supports using DataWindow expressions in , , , , and rules.
DataWindow Property Expressions – supports .
DataWindow Data Expressions – provides a set of methods to achieve the same results of DataWindow Data Expressions, e.g., , , , and .
Child DataWindow - supports using child DataWindows, and provides the method to manipulate data.
Dynamic DataWindow Technique – supports and to the .NET DataStore. It also supports dynamically accessing the DataWindow data via and .
Generic APIs – provides a set of generic APIs that make coding more concise and type safe, thereby significantly boosting development productivity.
Expanded Functions – 申博体育 supports aggregate functions (e.g., , , , ), and data buffer access & manipulation functions (e.g., , , , ), through generic interfaces.
.NET DataStore explicit can be managed in the same way as PowerBuilder; or
申博体育Use implicit transaction management provided in to create complex multi-type transactions with minimal coding.
It provides multiple methods (e.g., , , or ) to facilitate the data exchange between the PowerBuilder Client and REST API Projects.
.NET DataStore is a valid type in the REST API actions.
System Functions – The .NET DataStore together with C# provides robust support for commonly-used PowerScript functions. Many PowerScript system functions already have equivalent native methods in C#, and the .NET DataStore adds support for an additional 70 non-visual system functions. These system functions are provided as either or of the C# data type.
It automatically generates C# POCO models from existing DataWindows, DataStores, and ChildDataWindow. XML import/export templates are also converted.
Allows you to batch convert multiple DataWindows at once.
It supports various leading rational database including SQL Server, Oracle, SQL Anywhere, PostgreSQL, MySQL, SQLite.
It supports converting DataWindows from most versions of PowerBuilder:
- Sybase PowerBuilder 8-12.5
- SAP PowerBuilder 12.6
- Appeon PowerBuilder 2017-2019 R2
The .NET DataStore is the most effective technology for PowerBuilder customer to move to the Cloud with an API-enabled architecture.
The .NET DataStore is available as part of either PowerBuilder CloudPro or RapidSharp.