ApexSQL Code

ApexSQL Code provides template based code generation for any language used with Microsoft SQL Server. Comes complete with a large collection of templates in a template library.

• Do you spend a lot of time manually writing Data Access Layer code, stored procedures or even forms for CrUD (Create, Update Delete)? 
• Have you ever "fat fingered" names of parameters, datatypes or made other common errors in blocks of rote, repetitive code leading to annoying errors?
• Would you rather spend time designing software than typing code?
• Would you like to ensure you code base is more standardized with each class and function written the exact same way?

ApexSQL Code solves all of the above problems.

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 ApexSQL Code)

ApexSQL Code Features:

• [NEW] SQL 2005 Support
• [NEW] New Auto-update feature
• A template wizard that makes creating templates as easy as following 7 simple steps
• A template property page for editing templates in place with simple picklists and dialogs
• XML based templates - allows for template attributes to be embedded directly in the template structure itself.
• Built in Session and Application variables
• 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
• ApexSQL 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 ApexSQL 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
• ApexSQL 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 ApexSQL 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

What support options are available?
ApexSQL offers support via their Support Forums as well as Phone support and Priority for email/support forum requests for customers who have purchased a Maintenance Contract for Support and Upgrades.