ApexSQL Code - Summary
by ApexSQL
Summary
ApexSQL Code by ApexSQL
Increase productivity, reduce errors, standardize your code base and automate repetitive coding tasks with template based code generation. ApexSQL Code is a Rapid Application Development (RAD) code generation tool, streamlined specifically for Microsoft SQL Server, that enables you to automatically generate thousands of lines of C#, VB.NET, ASP.NET, SQL (and more) in just seconds.
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
PartNumbers: PC-517553-116771 517553-116771 PC-517553-116772 517553-116772 PC-517553-116773 517553-116773 PC-517553-116775 517553-116775 PC-517553-116776 517553-116776 PC-517553-116777 517553-116777 PC-517553-116778 517553-116778 PC-517553-116780 517553-116780 PC-517553-116781 517553-116781 PC-517553-116782 517553-116782 PC-517553-116783 517553-116783 PC-517553-116785 517553-116785 PC-517553-116786 517553-116786 PC-517553-116787 517553-116787 PC-517553-116788 517553-116788 PC-517553-116790 517553-116790
Publisher PartNumbers: 141575 300074483 300074485 300074486
PurchaseOptions: ApexSQL Code 2005.13 without Support 1 Client License , ApexSQL Code 2005.13 without Support 1 Client License per license from 2 to 4 Licenses , ApexSQL Code 2005.13 without Support 1 Client License per license from 5 to 9 Licenses , ApexSQL Code 2005.13 without Support 1 Client License per license from 10 Licenses , ApexSQL Code 2005.13 with 1 yr Support & Upgrades 1 Client License , ApexSQL Code 2005.13 with 1 yr Support & Upgrades 1 Client License per license from 2 to 4 Licenses , ApexSQL Code 2005.13 with 1 yr Support & Upgrades 1 Client License per license from 5 to 9 Licenses , ApexSQL Code 2005.13 with 1 yr Support & Upgrades 1 Client License per license from 10 Licenses , ApexSQL Code 2005.13 with 2 yr Support & Upgrades 1 Client License , ApexSQL Code 2005.13 with 2 yr Support & Upgrades 1 Client License per license from 2 to 4 Licenses , ApexSQL Code 2005.13 with 2 yr Support & Upgrades 1 Client License per license from 5 to 9 Licenses , ApexSQL Code 2005.13 with 2 yr Support & Upgrades 1 Client License per license from 10 Licenses , ApexSQL Code 2005.13 with 3 yr Support & Upgrades 1 Client License , ApexSQL Code 2005.13 with 3 yr Support & Upgrades 1 Client License per license from 2 to 4 Licenses , ApexSQL Code 2005.13 with 3 yr Support & Upgrades 1 Client License per license from 5 to 9 Licenses , ApexSQL Code 2005.13 with 3 yr Support & Upgrades 1 Client License per license from 10 Licenses
Resources: Read the ApexSQL Code help file, Read the ApexSQL End User License Agreement, Download the ApexSQL Code 2005.13 evaluation on to your computer - Expires after 30 days
Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows 2000
Architecture of Product: 32Bit
Compatible Containers: Microsoft SQL Server 2005, Microsoft SQL Server 2000, Microsoft SQL Server 7.0
Keywords: ApexSQL Apex SQL SQL query language Code Creation Editing Professional Partner ApexSQL Code
