Database Management in PowerBuilder .NET

You can manage a database from within PowerBuilder.

For the most part, the Database painter works the same in PowerBuilder .NET as in PowerBuilder Classic.

PowerBuilder 12.5 provides enhanced support for connecting to any .NET provider through a managed ADO.NET interface. You can use the built-in ADO.NET drivers for Oracle, Adaptive Server Enterprise™, and SQL Server from PowerBuilder Classic or PowerBuilder .NET applications. These drivers enable you to access most of the current database features of those providers.

See New Features in PowerBuilder 12 in the online help.

• Defining Database Profiles
  You can edit an existing database profile or create a new one.
• The Database Painter in PowerBuilder .NET
  Like the other PowerBuilder tool windows, the Database painter contains a menu bar, customizable PainterBars, and several views.
• Manipulating Data in the Database Painter
  As you work on the database, you might want to look at existing data or create some data for testing purposes. You might also want to test display formats, validation rules, and edit styles on real data.
• SQL Statements in the Database Painter
  The Database painter's Interactive SQL view is a SQL editor in which you can enter and execute SQL statements. The view provides all editing capabilities needed for writing and modifying SQL statements.
• DSI Database Trace Tool
  The DSI Database Trace tool is a managed database interface that records the internal commands PowerBuilder executes while accessing a database.
• Sharing ADO.NET Database Connections
  PowerBuilder WPF applications can share database ADO.NET connections with third-party .NET assemblies.