PRODUCT INFO
LINKS LOCALIZED DATASHEETS
TOP REASONS TO BUY
PRE SALES QUESTION?
ApexSQL Univ Studio
$1,999
All ApexSQL Tools with 1 yr Maint and all New tools Free for 1 yr. Click Here for more info.
ApexSQL Dev Studio
$999
All 7 ApexSQL Developer Tools - One Download / Discounted Price. Click Here for more info.
SALES FAQs
Killer Discounts
Unbeatable Killer Upgrades and Discounts. Click Here for more info.
ApexSQL Gear
Click Here for our ApexSQL Gear Store.
SUCCESS STORIES
Paul Barbin
DBA
Lewis, Inc.
Scott C. Dixon, MCP, MCP+SB, MCSD
Tech Consultant
CTGi
Paul Ohlemacher
Developer
Execupay
Alex Gadea
Sr. VP of Operations
Hostcentric Inc.
Brian Johnson
MIS Manager
FSBDC Network
Richard Dablo
Project Manager
Quest Diagnostics Clinical Trials
Increase productivity - Reduce Errors - Standardize your Code Base -
Automate repetitive coding tasks with Template Based Code Generation
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 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 perfect C#, VB.NET, ASP.NET, SQL (and more) in just seconds solving these problems and making good coders even better.
|
Product Information
|
|
){kind=link}
)
)
)
)
)
)
)
)
)
)
)
)
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)
- [NEW] Improved compiler error handling.
- [NEW] Tracing support (Debug.Write, Trace.Write etc).
- [NEW] Nested Template support.
- [NEW] Output File Encoding.
- [NEW] Code Snippets.
- [NEW] Improved Intelliprompt for C# and VB.NET Script Language.
- [NEW] New Template Editor options including Outlining and Auto-Replace.
- [NEW] Customizable Datatype mapping.
- [NEW] Support for User Defined Functions in Schema Explorer.
- [NEW] New Properties support including Collation, Definition and Extended Properties.
- [NEW] SQL 2005 Support
- [NEW] New Auto-update feature
- 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.
- 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 C# or VB.NET 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.
- 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.
- Templates can be Parsed for simple scripting mistakes like missing starting or closing tags.
"A word of congratulations. I think that your suite is some of the best stuff I have ever used. I had to add auditing to an existing SQL Server and your Audit product did that effortlessly and flawlessly. The client loves the solution.
I am now migrating from an Access GUI to a 4 tier .NET solution. I used ApexSQL Code to generate all the sprocs and yesterday built the templates for all the CSHarp Data Access Layer and Models. It all went perfectly.
I am also impressed by your rapid response to issues and feedback. Keep up the good work."Paul Ohlemacher
Developer
Execupay"very good news...we have an enterprise system with 897 stored procs (200,000+ lines of T-SQL)...750 of them !!! are Code generated from a script of less than 1000 lines of vb script...exposing the index collection on the views will allow us to generate another 40 or 50 of them...thats bottom line code maintenance savings...Code rocks...looking forward to it...this is the singe biggest savings of team time/dollars I've ever experienced in my development career..thanks"
Michael C. Pinkus
Software Project Manager
Scientific Games Corporation"The ApexSQL Code system is so easy to use that we were able to create fully functional 1 Click DB Wizard templates in just a few hours !! This development time even included asking a bunch of dumb questions to the fast friendly support offered by ApexSQL. Since 1 Click DB already encapsulates much of the complexity of using Active Server Pages and Dynamic SQL to Browse/Search/Export/Add/Edit/Delete information from your database, template development is pretty much a no-brainer for us. However, the resulting ApexSQL Code templates are easy to read, modify, and extend using the very attractive and functional graphical user interface provided by ApexSQL. ApexSQL Code also comes with an advanced code editor that is good enough to at least consider using as your main development environment."
Excerpt from http://1clickdb.com/kb/KB98734567.asp?clickfrom=lwt 1ClickDB Knowledgebase
Dave Kawliche
Founder
1ClickDB"This [ApexSQL Code] not only addresses productivity, but also adherence to standards, best practice adoption, code consistency & knowledge transfer (which is key as I bring on some interns this summer).
On top of all that the scripting model you chose to use for the templates rocks! It's the most flexible code-gen tool I've seen."
Tim Weisbrod
Inphonic"...By the way, the more I user your product [ApexSQL Code], the more I really think your product is excellent and a real timesaver."
Michael Bunger
"... and finally, thank you. What with moving to real scripting for the templates, producing templates for the .Net environment, and finally getting templates to script out classes that work with the generated sprocs, you have come a long, long way and deserve congratulations. This is turning into an extremely useful product [ApexSQL Code]."
Patrick Crawford
Vasptech"ApexSQL Code allowed us to meet an intensely aggressive launch deadline despite the best efforts of Microsoft ADO documentation. A majority percentage of ADO code used in the final product version was cut-and-pasted directly from ApexSQL Code output. Highly recommend!"
Tim Rogers
Sr. Software Engineer LifeClips"ApexSQL Code is one cool developer's tool! It has saved me weeks of coding and enabled RAD development of several of our web apps. We're running ASP with a SQL Server 2000 backend. The Blaster writes both the ASP VBScript classes and the SQL Stored Procedures, a definite time-saver."
Brian Johnson
MIS Manager
FSBDC Network"...we adopted Sheridan's Code-Assist for our code generation needs several months ago. Its a little more versatile in that you can configure templates to generate your code, but it is no where near as straightforward as your tool [ApexSQL Code Professional] (I've spent about a week re-writing and troubleshooting class and sproc templates). So congrats on a really great, clean and simple tool, that generates elegant code right out of the box."
James Street
CamSoft Data Systems