simple-.NET-Crypting-For-PB

This Project will create .NET dll for Powerbuilder (Bcrypt PW hash, AES-GCM and ECDH) also for MS-SQL

Read this in other languages: 한국어

Purpose

• AES-GCM, Bcrypt PW hash, ECDH
• Implement simple dll for Powerbuilder Programming
• Also Supplement Assembly for SQL Server will used in SP for Powerbuilder Clients

Informations

• Target Frameworks

  • .NET Framework 4.8.1
    • This is ensure Cross compatibility between PB versions
    • Also for SQL Server CLR Assembly
    • Download .NET Framework 4.8.1
      • to run DLL, runtime needs to be installed, powerbuilder dev needs SDK installed windows PC
      • Required windows 10 21H2 or later and windows server 2022 or later
  • .NET 8
    • This is for Powerbuilder 2022 R3 Latest or 2025
    • Download .NET 8
      • to run DLL, runtime needs to be installed, powerbuilder dev needs SDK installed windows PC
      • we need .NET Desktop Runtime for windows
      • Required windows server 2016 or later and windows 10 (LTSC 1607+ or 22H2) or laters

• Example Code

  • PB with .NET 4.8.1 DLL
  • PB with .NET 8 DLL
  • MS-SQL with .NET 4.8.1 DLL

Cause of Not Implemented some cryptographic options In Powerbuilder

For Example

• AES Encryption with GCM mode
  • This is important to secure using Symmetric Encrypting Function in morden
• ECDH Key Exchange
  • for 2nd layer securing to transport sensitive data
  • (In TLS already used, but bi-layered encrypt for more secure handling)
• Bcrypt Password encoding
  • this is the matter of one-way password encryption well
  • just using 1 pass of hash function, eg. SHA-512 isn't secure enough

Build Information

You can build in supported windows environment, and you can check required commands in github actions you should see ci.yaml and cd.yaml

Dependancy

• .NET or .NET Framework
• Windows Cryptography API: Next Generation
• Bcrypt.NET-NEXT