Apex SQL Code

How long would it take you to write all of this code by hand? ... or how about this C# Class?  The answer .... it would only take a few seconds to generate this code if you use Apex SQL Code code generator.

Apex SQL Code is a Rapid Application Development (RAD) Code Generation tool for Microsoft® SQL Server© 7 or 2000 that enables you to automatically generate thousands of lines of perfect ASP, VB, C#, SQL (and more) code in just seconds

The key feature of Apex SQL Code is Template based code generation that allow users to configure custom code patterns automated with the scripting language of your choice, VBScript or JScript.

Coming Soon in version 3.0 ...    

• Command Line / Batch Interface
• Completely redesigned interface
• Scores more templates for UI design, Documentation and more
• Better FK support
• More object model properties

Features

• [NEW] A cool template wizard that makes creating templates as easy as following 7 simple steps.
• [NEW] A powerful template property page for editing templates in place with simple picklists and dialogs.
• [NEW] XML based templates - allows for template attributes to be embedded directly in the template structure itself.
• [NEW] Built in Session and Application variables.
• [NEW] Programmatic control of file operations and dialogs directly from the template.  Files can be output, appended or all file operations can be suppressed if user chooses to use File System Object.
• [NEW] Apex SQL Code now automatically remembers all of your table, view, sproc, field, parameter and result column selection in between sessions and for a specific database.  These selection profiles can be saved, cleared and retrieved.
• Choice of VBScript of JScript for template scripting - handles looping including For Each loops, constructs, error handling, etc.   Your ability to create code patterns is virtually unlimited.
• Extensive template library including C#, VB.NET, AsP, VB, SQL and Delphi templates
• Support for unlimited Include files just like ASP!
• Real Intellisense to navigate Apex SQL Code object Model
• Default color coded text editor to manage templates currently supports ASP / VBScript, VB, Java / JScript, CSharp and SQL.
• Multiple tables, views and stored procedures can be scripted at once and even in the same template.
• Intelligent variable typing allows you to strongly type all VB variables (i.e. long), always use variants or use variants only for NULLABLE fields in the database.
• Scripting engine allows programmatic access to any COM object installed on user's computer including FileSystemObject
• Error handling shows exact line of error allowing for easy diagnosis of errors and de-bugging.
• Apex SQL Code object model allows easy extraction of information.  Read-Only properties are used to create code patterns but object model also exposes Read-Write properties that can be controlled programmatically.  
• Pre-Processing of templates - now various Apex SQL Code settings like language, programming language and output file can be controlled via the template itself.
• Templates can be Parsed for simple scripting mistakes like missing starting or closing tags and version incompatibilities.

Awards

What's it For?

Here are just a few examples ...

• Create Data Access layer code based on underlying tables, views or stored procedures
• Create complete web forms in ASP.NET (C# and VB.NET) to work with your existing database
• Automatically created stored procedures for select, update, delete and insert on tables
• Construct an ADO Command object with parameters for large stored procedures with many input and output params
• Document your sql server database into HTML by using database object scripts
• Create a trigger based auditing system (templates included with Apex SQL Code)

Screenshots

Customer Comment

"I congratulate you on the decision and the approach of free upgrades for life as it is a rare opportunity to see that these days, when most other software companies want more and more money for the things we as users already paid for. I think that if you believe in your product it will speak for itself"

Vilko Poznovia
Database Administrator
Silver Chain
Perth, Western Australia

Order

We are a leading provider of value SQL tools for Microsoft SQL Server developers

Single Developer License - for only one SQL Server databases Developer

Site Developer License - for many SQL Server databases Developers

Home   More Software  More Apex Sql Products

  More Software     More Car Software   Excel Spreadsheets