Stored Procedures

Another key enhancement for version 2.0 is the generation of structured code based on custom Stored Procedures.

The generation of structured code for Stored Procedures led to the creation of a new class of database related objects: Virtual Views.

Virtual Views
Virtual Views are used to represent the result-set of Stored Procedures. You may also choose to represent the result-set using Tables, Views, or a small selection of system types.

MultiResultset
To propagate the data from a Stored Procedure that returns multiple result-sets, a specialized class, the MultiResultset, is used.
The MultiResultset class is exceedingly simple and inherits from List (List of T). As always, the code will be part of your project.

Command Execution
OxyGen Code version 2.0 supports all the command execution types as well as a few derived ones.

ExecuteReader

ExecuteNonQuery

ExecuteNonQuery (with rows affected)

ExecuteNonQuery (with row count)

ExecuteScalar

ExecuteXmlReader

ExecuteSingleRow

Stored Procedures that use the ExecuteXmlReader execution type have the option of three System types as return types: System.Xml.XmlDocument, System.Xml.XmlReader, System.String.

Since some databases may contain hundreds of stored procedures, two new wizards have been created to help with the configuration of Stored Procedures:

The Virtual View Generator

The StoredProcedure Generator

Explore

How To

 

Please use the forums for questions.