c-treeACE V11.0 Update Guide

Latest c-treeACE SQL Features

c-treeACE SQL brings standards-compliant SQL to even your most non-SQL data. You’ve invested years in your successful c-tree applications. Now you can enjoy fresh new interfaces and capabilities while maintaining strong and proven c-tree foundations. Many applications are already reaping the benefits. And with that, many requests for extended SQL capabilities have been suggested. c-treeACE SQL V11 brings a list of great new features.

Stored Procedure Development in the .NET Framework - C#

SQL stored procedures and triggers are an easy and powerful way to move advanced logic into your server core, protecting investments in performance-sensitive processing while maintaining a centrally managed approach for long-term maintenance. Stored procedures fully encapsulate business logic for business rule enforcement. Triggers maintain database integrity directly at the database server level.

c-treeACE SQL has long supported stored procedures, triggers, and user defined functions with Java for cross-platform development ease.

Stored procedures are now available for your Microsoft Windows .NET development environment. Program your procedure in C# or any other .NET supported language. Seamlessly remain in your .NET environment while developing advanced server-side processing logic. With Visual Studio integration, it is easy to create, debug, and deploy your C# stored procedure code remotely. Your assemblies are deployed alongside c-treeACE SQL with a click of a mouse.

See New Stored Procedure Development Frameworks.

NetBeans Plugin for Java Stored Procedure Development

c-treeACE SQL now includes a Java NetBeans plugin (NetBeans Plugin for Java Stored Procedure Development, /doc/jspt/62755.htm) for advanced development potential. Take advantage of the complete NetBeans IDE in creating and maintaining new and existing Java stored procedures. Existing Java stored procedure investments can continue to be used with much easier maintenance and deployment capabilities. See NetBeans Plugin for Java.

More SQL Enhancements

c-treeACE SQL includes a list of many other big new additions for easier and enhanced SQL capabilities with your existing applications:

• Entity Framework 6 Support with ADO.NET
• SQL Groups for much easier user role management
• Table Valued Functions for dynamic calculated tables in queries based on stored procedure logic
• Extended ALTER VIEW, ALTER TABLE, and ALTER INDEX Flexibility for views, tables, and index management
• Table Locks for exclusive user access
• Recursive Query support for hierarchal “tree”-based queries
• Scrollable Cursors
• And continued query optimizer improvements for ever faster performance

Collectively, these great new SQL features bring enhanced administrative capabilities to new and existing applications.