Data Commands

Business Object Generator Virtual Business Object Generator Extract DTO Class Xmlize Type

Business Object Generator (C#, VB.NET)

Top

Creates class types for Database Tables from within VS IDE. A must have feature in your toolbox if you work with databases regardless you use OR/M or not.

Supported Database Servers:

• Microsoft SQL Server (2000, 2005, and 2008)
• Microsoft SQL Compact Edition 3.1 and 3.5
• Microsoft Access
• Oracle (supports the same versions that .Net provider support)
• Firebird 2.x (Supports Array Types)
• MySQL (MySql Direct and CoreLab providers are supported)
• PostgreSQL (Supports array types, multidimensional array types, enum type, and multidimensional enum types)
• Sqlite 3.x ((Phxsoftware and CoreLab providers are supported). Virtual Tables are considered as Views in IntelliCommands
• VistaDB 3.x 

Features:

• Editable Class Name
• Modifiable Entity visibility access
• Modifiable Entity inheritance type i.e. abstract and sealed in C# and MustInherit and NotInheritable in VB.NET
• Editable Properties Name
• Modifiable Property visibility access
• Individual Properties can be set to be virtual (Overridable in Visual Basic)
• String Properties can be generated to return String.Empty instead of null
• Optional synchronisation supports (see below for more details)
• Supports various options to generate the entities (please see below for more details)
• Connection Management. ConnectionStrings can be saved for repetitive use.

Synchronisation Features:

• Adds the missing properties (Columns)
• Synchronises Column/Property types
• Synchronises property inheritance kind
• Synchronises property and entity visibility access
• Synchronises property XmlAttribute attribue
• Optional reconstruction of overloaded Dispose() metbod. When enabled custom codes will be lost, if any.
• Optional reconstruction of ISerializable methods. When enabled custom codes will be lost, if any.

Generation Options:

• Optional collection type for each entity  
• Optional Implementation of ISerializable, IDisposable, and ICloneable for entity types
• Optional Xmlizing the entity types
• Optional Regionizing both the entity types and entity collection types
• Optional Implementation of IDisposable for entity collection types.
• Project Folder selection
• Configurable entity collection type, same as Extract Collection Type from Type command

Virtual Business Object Generator (C#, VB.NET)

Top

Same as Business Object Generator except it is used for View objects.

Extract DTO Class (C#, VB.NET)

Top

The concept behind this command is to create DTO (Data Transfer Object) from existing Business Objects. In Software Development principal you would not pass an object to another layer when you do not wish the consumer to have the ability to call public methods. In such scenarios, one solution would be to create a new object template to hold the data that the consumer would expect. Extract DTO Class command makes it very easy to create such object templates. Please review the supported features in this command below:

Features:

• Property selection (ReadWrite and ReadOnly). Except indexers.
• Optional implementation of IDisposable, ISerializable, and ICloneable
• Automatically creates a constructor for ReadOnly properties.
• Properties can be declared as:
  • Same As Type (the properties in DTO would have the same accessors as the type)
  • ReadOnly (Regardless of the enclosing type all properties would be declared as ReadOnly and a constructor would be created to pass values to DTO type)
  • ReadWrite (Regardless of the enclosing type all properties would be declared as ReadWrite in DTO type)
• Optional explict casting from active type to DTO type
• Various optional settings to increase usability
• Optional Regionization
• Project Folder Picker

Xmlize Type (C#, VB.NET)

Top

Xmlizing Type is a posh name for adding supports to instance class types to return XmlDocument and XmlString.