OxyGen Code Generator Overview. 4   Table of Contents. 4
Next Topic: Processing Instructions. 4

The aim of this document is to help the reader answer the question "What is OxyGen Code?"

OxyGen Code is a code generator that produces C# and T-SQL source code for the Data Access, Business, and Presentation Layers of a typical .NET application.

Some of the key features of OxyGen Code are:

• Relationships between entities or tables are taken into account.
• Custom queries may be introduced.
• A configurable data search mechanism is available.
• Specialized entities can be created for static (reference) data
•  A replaceable, independent, Business Layer caching mechanism is available.
• Data source based paging mechanism is available.
• Business Layer relationship de-normalization is possible.
• The generation of the complete data manipulation sub-stack
• Custom Stored Procedures are seamlessly handled including full XML support and multiple result-set scenarios
• Table Virtualization for database Views (in certain scenarios, you may transfer base table behaviours to views)
• Code Publication: precisely inject and merge code in a highly controlled manner

 Other features of OxyGen Code are:

• An object-based Data Access Layer.
• An object-based Business Layer.
• Built for existing databases: existing production databases will not need to be redesign for an “Application Model”.
• Supports the Provider Independent Model for ADO.NET data providers (Microsoft Corporation)
• The Custom Stored Procedure Configuration Wizard

OxyGen Code is meant for .NET software professionals in a SQL Server environment.

Typically, in-house architects/developers and enterprise consultants will find it the most useful. It’s ability to generate code that covers the typical data-centric application scenario (Create, Read, Update, Delete, Page and Search) can be a big time saver. OxyGen Code Generator may generate upwards of 80% of all the code required by the typical data-centric application.

The current trend with most code generation tools available is to deemphasize the time proven benefits of structured, layered code.

OxyGen Code is the complete opposite. It generates structured, layered, readable and commented code without sacrificing on the ease of use of the output.

Although OxyGen Code transparently generates code for SQL Server based databases, the generated code may be used against other Database Management Systems as well. This is possible because the Data Access Layer is built around the ADO.NET Generic Data Provider model. This will require creating an equivalent SQL Server database however.

There are three ways to use OxyGen Code:

i)                     Standalone Application (OCMS Application)

ii)                   Microsoft Visual Studio Add in

iii)                  The Command Line (OCG.exe)

OxyGen Code Generator Overview. 4   Table of Contents. 4
Next Topic: Processing Instructions. 4