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.
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:
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#.
DataWindow Property Expressions – supports accessing model metadata via dot notation.
Child DataWindow - supports using child DataWindows, and provides the GetChild method to manipulate data.
Generic APIs – provides a set of generic APIs that make coding more concise and type safe, thereby significantly boosting development productivity.
.NET DataStore explicit transactions can be managed in the same way as PowerBuilder; or
Use implicit transaction management provided in SnapObjects to create complex multi-type transactions with minimal coding.
.NET DataStore is a valid parameter 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 class methods or extension methods 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.