ApexSQL Code 是一种快速应用开发(RAD)代码生成工具,特别是简化了 Microsoft SQL Server,让你自动产生上千行完美的 C#,vb.net,asp.net,sql 等,在几秒钟内解决s这些问题,并已取得良好的编码。
ApexSQL Code is a Rapid Application Development (RAD) Code Generation Tool for use with SQL Server that creates custom code patterns in a variety of languages like VB, ASP, C#, VB.NET, Delphi etc.
A template wizard that makes creating templates as easy as following 7 simple steps.
A powerful 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.