decide consulting
 

conclusion©


Data Layer Generation

Introduction

Decide's Conclusion is a tool that can automatically generate data layer components in one of four ways. From one of the UI Component code generation screens the user can add an external assembly as a new data layer or generate new data layers from existing data layers. Users can also generate Web Service Proxy data layers. These methods are explained elsewhere in the help. Lastly users can use the Data Layer generation window to direct Conclusion to go into a target database, analyze the stored procedures, and generate a code block for a data layer component. Generated code can be in any language that Conclusion "templates" support, currently C# and Visual Basic. There are four steps for accomplishing this:

  1. Choose the stored procedures for which the data components will be created.
  2. Choose the types of data layer components that will created for the chosen procedures by selecting templates.
  3. Customize the Methods and Method Names that will be created in the component.
  4. Generate, review, and save the data layer code files.

Generation Screens

Throughout Conclusion the code generation screens all take the same format. They can be accessed from the Main Menu's Generate menu. A menu will pop up with three tabs. The first tab allows users to choose from a list box on the left to select the source of code generation and to select templates from a box on the right. Under the Source checkboxes there will be two or three buttons:

  • ALL: Automatically selects all items
  • None: Automatically unchecks all items
  • Delete: Allows deletion of checked items from the list (not available on stored proc screen)
The data layer generation window's data source list contains stored procedures found in the target database. The template window contains Conclusion templates - one for each type of data layer that can be generated for each selected data table. Once selections have been made the user can click the Next button to bring up the Methods tab.

Customizing Output

Within Conclusion it is possible to customize the Method names involved in the generated components. The Methods tab will have a grid where users can configure the names involved. From there users can click the Generate button to perform the code generation.

The Code Window

The code window shows all the generated code for all the selected items and templates. After generation they still only exist in memory but users can click the Create Files but to write the code to individual files in the Conclusion Results folders. The results folders are configured in Project Setup screen from the Main Menu's File menu.


Conclusion Ver 1.4 - WGU 3/10/2005