ApexSQL Code - Application - 2005.13 - Sommario

di ApexSQL

Sommario

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-116774 517553-116774 PC-517553-116775 517553-116775 PC-517553-116776 517553-116776 PC-517553-116777 517553-116777 PC-517553-116778 517553-116778 PC-517553-116779 517553-116779 PC-517553-116780 517553-116780 PC-517553-116781 517553-116781 PC-517553-116782 517553-116782 PC-517553-116783 517553-116783 PC-517553-116784 517553-116784 PC-517553-116785 517553-116785 PC-517553-116786 517553-116786 PC-517553-116787 517553-116787 PC-517553-116788 517553-116788 PC-517553-116789 517553-116789 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 3 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 to 15 Licenses , ApexSQL Code 2005.13 without Support 1 Client License per license from 16 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 3 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 to 15 Licenses , ApexSQL Code 2005.13 with 1 yr Support & Upgrades 1 Client License per license from 16 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 3 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 to 15 Licenses , ApexSQL Code 2005.13 with 2 yr Support & Upgrades 1 Client License per license from 16 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 3 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 to 15 Licenses , ApexSQL Code 2005.13 with 3 yr Support & Upgrades 1 Client License per license from 16 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