SmartCodeGenerator CTP 2.3 Released

Topics: SCG Releases, Release Notes, Announcement
Coordinator
Dec 12, 2006 at 10:00 AM
In addition to the existing releases the CTP 2.3 Release includes Brand New DBSchemaProvider.

Implemented DBSchemaProviders includes:
MySql and Oracle

The following Classes introduced to Explore Database Schema and Resides in the SmartCodeGen.Providers namespace:
ColumnSchema
ColumnSchemaCollection
CommandResultColumnSchema
CommandResultColumnSchemaCollection
CommandResultSchema
CommandResultSchemaCollection
CommandSchema
CommandSchemaCollection
DatabaseSchema
ExtendedProperty
ExtendedPropertyCollection
IndexSchema
IndexSchemaCollection
ParameterSchema
ParameterSchemaCollection
PrimaryKeySchema
TableKeySchema
TableKeySchemaCollection
ViewColumnSchema
ViewColumnSchemaCollection
ViewSchema
ViewSchemaCollection

The signature of the DBSchemaProvider is as follows:
public abstract ParameterSchemaCollection GetCommandParameters(CommandSchema command);
public abstract CommandResultSchemaCollection GetCommandResultSchemas(CommandSchema command);
public abstract CommandSchemaCollection GetCommands(DatabaseSchema database);
public abstract string GetCommandText(CommandSchema command);
public abstract string GetDatabaseName(DatabaseSchema database);
public abstract ExtendedPropertyCollection GetExtendedProperties(SchemaBase schemaObject);
public abstract ColumnSchemaCollection GetTableColumns(TableSchema table);
public abstract DataTable GetTableData(TableSchema table);
public abstract IndexSchemaCollection GetTableIndexes(TableSchema table);
public abstract TableKeySchemaCollection GetTableKeys(TableSchema table);
public abstract PrimaryKeySchema GetTablePrimaryKey(TableSchema table);
public abstract TableSchemaCollection GetTables(DatabaseSchema database);
public abstract ViewColumnSchemaCollection GetViewColumns(ViewSchema view);
public abstract DataTable GetViewData(ViewSchema view);
public abstract ViewSchemaCollection GetViews(DatabaseSchema database);
public abstract string GetViewText(ViewSchema view);

// Properties
public abstract string GetDescription();
public abstract string GetName( );