Click here to Skip to main content
15,881,516 members
Articles / Database Development / SQL Server
Article

Business Objects for CodeSmith

Rate me:
Please Sign up or sign in to vote.
4.38/5 (17 votes)
23 Nov 2004Ms-PL6 min read 143.8K   719   105   27
Save time when developing large applications, by using code generation for your business objects.

Sample Image - BusnessObjectGenerator.gif

Introduction

One of the biggest issues a developer faces when developing a large application, is maintaining design standards and methods. Design documents, coding standards, and code review were the only tools a developer had to work with in the golden days of coding. With the birth of code generators such as CodeSmith, development teams are now armed with a powerful tool to expedite the development process and maintain a standard throughout the application. When developing applications, templates can save you a lot of time by using common design patterns for generating different business objects. By definition, templates are repeatable patterns, which can be derived from any design methods. The benefit of using templates in code generation is the ability to enforce design methods and standards while saving development costs for any application. This article will present a basic design pattern and the templates to generate code for the design pattern.

Business Object Design Pattern

Business objects contain properties that reflect data; you will find objects named invoice, invoice detail, etc. Commonly, they include embedded relationships -- for example, an invoice object may have a property that retrieves the details for that invoice instance.

Based on this simple observation, we can develop a design standard for our business objects:

  • Business Objects Contain Properties
  • Business Objects Require Collections
  • Business Objects Require Access Data

Business Object:

The Business Object Class Template (ClassGenerator.cst) is used to create a business object’s properties and methods. A standard set of methods for accessing the object's data will be generated for each object defined in an XML document. The following methods will be created for each business object defined:

Public Static Methods
  • CreateNewObject: Creates a new Object.
  • DeleteObject: Deletes an Object.
Public Instance Constructors
  • Object - Overloaded. Initializes a new instance of the Object class.
Public Instance Methods
  • Copy: Copies an Object.
  • Delete: Deletes an Object.
  • Fetch: Fetches an Object.
  • Save: Saves an Object.
  • Update: Updates an Object.

Business Object Collection:

The Business Object Collections Template (CollectionGenerator.cst) is used to create a collection class for each business object. The collection object uses the 'CollectionBase' as the base class. The following methods will be created for each business object defined:

Public Instance Constructors
  • ObjectCollection: Constructor initializes a new instance of the ObjectCollection class.
Public Instance Properties
  • Count: Gets the number of elements contained in the CollectionBase instance.
  • Item: Gets or sets the value associated with the specified key.
Public Instance Methods
  • Add: Adds an item to the Object Collection.
  • Contains: Determines whether the Object Collection contains a specific Object.
  • IndexOf: Determines the index of a specific item in the Object Collection.
  • Insert: Inserts an item to the Object Collection at the specified position.
  • Remove: Removes the first occurrence of Object in the Object Collection.
Protected Instance Methods
  • OnInsert: Validates before inserting a new Object into the Object Collection.
  • OnRemove: Validates before removing a new Object from the Object Collection.
  • OnSet: Validates before setting an Object in the Object Collection.
  • OnValidate: Performs additional custom processes when validating an Object.

Business Object Data:

The Business Object Data Class Template (DataClassGenerator.cst) is used to define the data access layer for each business object. The following methods will be created for each business object defined:

Public Instance Constructors
  • ObjectData: Constructor initializes a new instance of the ObjectData class.
Public Instance Methods
  • CreateNewObject: Creates a new Object in the database.
  • DeleteObject: Deletes an Object from the database.
  • FetchObject: Gets a single Object from the database.
  • UpdateObject: Updates an Object in the database.

Base Object Classes:

The Business Object Base Class Template (BaseObjectClass.cst) is used to create the base class for each business object. The following are the properties used for each business object:

Public Instance Properties
  • Id: ID of Business Object.
  • Name: Name of Business Logic Object.
Internal
  • GenerateObjectId: Generates an ID for the given object.

Base Object Data Class

The Business Object Base Data Class Template (BaseDataClass.cst) is used to create the base class for each business object. The following are the properties used for each business object:

Public Instance Constructors
  • BaseDataClass: Constructor initializes a new instance of the BaseDataClass class.
Public Instance Properties
  • ConnectionString: Gets Connection String configuration from a config file.
Public Instance Methods
  • AddParamToSQLCmd: Adds a parameter to a SqlCommand.
  • ExecuteCollectionReader: Returns an object collection from a SQL Data Reader.
  • ExecuteObjectReader: Returns an object from a SQL Data Reader.
  • ExecuteReaderCmd: Generates Object Collection from SQL Data Reader.
  • ExecuteScalarCmd: Executes a query.
  • SetCommandType: Sets the CommandText property to the name of the stored procedure.

Data Layer Generator:

The Data Layer Template (DataGenerator.cst) is used to create the required database objects needed to support the business objects.

Procedures
  • Object_Create: Creates a new Object in the database.
  • Object_Delete: Deletes an Object from the database.
  • Object_Fetch: Gets a single Object from the database.
  • Object_Update: Updates an Object in the database.

Using the Generator

Based on a definition provided by an XML Document, the generator will produce code for your business object, business object collection, business object data access, business object tables, and stored procedures.

Business Objects Attributes

attribute

maps to

remarks

class

table

name will represent the table name

property

column

name will represent the column name

Class Attributes

attribute

remarks

name

represents the table name

Property Attributes

attribute

remarks

name

represents the column name

type

represents a system type or a business object collection

maxSize

 
Supported Types

C# Type

Maps to SQL type

string

nvarchar

int

int

DateTime

smalldatetime

bool

bit

decimal

money

Defining the Business Objects:

Let's create a simple Invoice Business Object. The invoice object will contain a customer name, invoice date, invoice paid status, and line items. The following XML document defines the objects:

XML
<?xml version="1.0" encoding="utf-8" ?> 
<BusinessObjects xmlns="http://www.austinconnergroup.com">
  <class name="Invoice">  
    <properties>
      <property name="Id" type="String" maxSize="36" />
      <property name="Customer" type="String" maxSize="96" />
      <property name="InvoiceDate" type="DateTime" maxSize="" />
      <property name="InvoicePaid" type="bool" maxSize="" />
      <property name="InvoiceDetails" type="InvoiceDetailCollection" maxSize="" />
    </properties>
  </class>
  <class name="InvoiceDetail">  
    <properties>
      <property name="Id" type="String" maxSize="36" />
      <property name="InvoiceId" type="String" maxSize="36" />
      <property name="LineItem" type="Int" maxSize="" />
      <property name="ItemDescription" type="String" maxSize="96" />
      <property name="ItemCostPerUnit" type="Single" maxSize="" />
      <property name="ItemQuanity" type="Int" maxSize="" />
      <property name="ItemUnit" type="String" maxSize="8" />
    </properties>
  </class>
</BusinessObjects>

In our definition document, we define two objects, Invoice and InvoiceDetail. You will notice that the Invoice object contains a property InvoiceDetails which is of the type InvoiceDetailCollection. This defines a relationship between InvoiceDetail and Invoice, and will produce the required methods and SQL statements for this relationship.

Running the Generator

Once we have our model, we are ready to generate our code. BuildTemplate.cst is the main entry point for generating the code for all the business objects, and has the following properties:

  • XmlFile - XML Document that the classes will be generated from.
  • OutputDirectory - The base directory for code output.
  • GenerateBaseClasses - Set true to generate base classes.
  • RootNamespace - The root namespace generated classes will be a member of.
  • ObjectNamespace - The object namespace generated classes will be a member of.
  • BusinessLogicNamespace - The business object namespace generated classes will be a member of.
  • DataAccessNamespace - The data object namespace generated classes will be a member of.
  • DeveloperName - Developer's name.
  • CompanyName - Company name.

Points of Interest

The article here presents the prototype that I developed for proof of concept. After writing the generator and supporting templates, I was so amazed at the results, I immediately wrote the templates for our team and deployed them into our production environment. One of the biggest benefits was not the cost savings in time, but the fact that all the generated code was self documenting. This fact alone was worth the efforts in creating these templates. The biggest battle I faced everyday was the lack of documented code, now it's a snap.

History

  • 11/23/2004 - Initial article.

License

This article, along with any associated source code and files, is licensed under The Microsoft Public License (Ms-PL)


Written By
Web Developer
United States United States
Software Architect with 20++ years of software design and development experience with a strong hold in Object-Oriented software engineering using UML with Design Patterns. Architected and developed several industrial software packages and passed through full software development life-cycle. Currently managing a small group of developers, developing management software for the agriculture industry.

Comments and Discussions

 
GeneralError when use template Pin
daica198112-Aug-09 22:54
daica198112-Aug-09 22:54 
GeneralRe: Error when use template Pin
ACG10019917-Aug-09 4:02
ACG10019917-Aug-09 4:02 
GeneralFailed Using Pin
asmaashafeik12-Feb-08 2:15
asmaashafeik12-Feb-08 2:15 
Generalfailed using Pin
asmaashafeik12-Feb-08 1:24
asmaashafeik12-Feb-08 1:24 
GeneralFailed using CodeSmith V3.0 Pin
SonnyDude20-Jul-05 15:57
SonnyDude20-Jul-05 15:57 
I have downloaded version 3.0. I managed to load the BusnessObjects_1_0.sln in Visual Studio (1.1) and recompiled it. I excluded the Sample Tester project out since I was getting problems loading it. I copied the DLL into the CodeSmith Templates directory (same level as the BusnessObjects_1_0 directory). But, when I load the any of templates in the CodeSmith (using File-Open), I am unable to run it. The property window is showing blank.

It underlines the <%@ Assembly Name="BusnessObjects.Templates" %> at the 2nd line saying “Unable to resolve the assembly BusnessObjects.Templates”

Does anyone have these templates for VB.net?
GeneralRe: Failed using CodeSmith V3.0 Pin
JR Hull12-Oct-05 3:54
JR Hull12-Oct-05 3:54 
GeneralRe: Failed using CodeSmith V3.0 Pin
nightsoul11-Apr-06 6:20
nightsoul11-Apr-06 6:20 
GeneralA note on business objects Pin
nedcod10-Feb-05 21:08
nedcod10-Feb-05 21:08 
GeneralRe: A note on business objects Pin
Anonymous25-Jul-05 23:41
Anonymous25-Jul-05 23:41 
GeneralVB version of Editor property attribute Pin
Bill_Philly16-Dec-04 5:55
Bill_Philly16-Dec-04 5:55 
GeneralRe: VB version of Editor property attribute Pin
JR Hull16-Dec-04 7:25
JR Hull16-Dec-04 7:25 
GeneralFxCop Pin
Ozitraveller11-Dec-04 14:16
Ozitraveller11-Dec-04 14:16 
GeneralRe: FxCop Pin
Bill_Philly12-Dec-04 15:02
Bill_Philly12-Dec-04 15:02 
GeneralRe: FxCop Pin
Ozitraveller12-Dec-04 15:54
Ozitraveller12-Dec-04 15:54 
GeneralRe: FxCop Pin
JR Hull13-Dec-04 3:28
JR Hull13-Dec-04 3:28 
GeneralPossible extensions?! Pin
Ozitraveller6-Dec-04 13:01
Ozitraveller6-Dec-04 13:01 
GeneralRe: Possible extensions?! Pin
JR Hull7-Dec-04 2:54
JR Hull7-Dec-04 2:54 
GeneralRe: Possible extensions?! Pin
Ozitraveller9-Dec-04 16:15
Ozitraveller9-Dec-04 16:15 
GeneralRe: Possible extensions?! Pin
JR Hull10-Dec-04 2:38
JR Hull10-Dec-04 2:38 
Generalfailed Pin
xqp19771-Dec-04 20:02
xqp19771-Dec-04 20:02 
GeneralRe: failed Pin
JR Hull2-Dec-04 2:33
JR Hull2-Dec-04 2:33 
GeneralRe: failed Pin
Brandon Hunt3-Dec-04 9:05
Brandon Hunt3-Dec-04 9:05 
GeneralRe: failed Pin
angel.carrillo7-Dec-04 3:20
angel.carrillo7-Dec-04 3:20 
GeneralRe: failed Pin
Brandon Hunt7-Dec-04 3:43
Brandon Hunt7-Dec-04 3:43 
GeneralRe: failed Pin
JR Hull7-Dec-04 3:45
JR Hull7-Dec-04 3:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.