Page Comparison

...

Before you can execute this template, you must supply a value for the SourceDatabase property. When you place your cursor in the property sheet row for this property, CodeSmith Generator will display a builder button (highlighted in green), indicating that there is an external editor hooked up for this property. CodeSmith Generator automatically uses editors built into SchemaExplorer:

Image RemovedImage Added

Clicking the builder button opens the Database Picker dialog box. A dropdown list lets you choose from all of the data sources that you have previously defined on your computer. There's also a builder button to define a new data source:

...

If you choose to add a new data source, SchemaExplorer opens the Data Source dialog box. To add a new data source, you must provide a name for the new data source, then select a provider type and type in a connection string. 

Image Added

It's worth noting that CodeSmith Generator ships with providers for SQL Server and ADOX data sources.Image Removedmany database providers including the following:

• ADOXSchemaProvider
• ISeriesSchemaProvider
• MySQLSchemaProvider
• OracleSchemaProvider
• PostgreSQLSchemaProvider
• SQLAnywhereSchemaProvider
• SqlCompactSchemaProvider
• SQLiteSchemaProvider
• SqlSchemaProvider
• VistaDBSchemaProvider

Here's a sample of the output for this template when it's used with the SQL Server Northwind sample database:

...

...