Schema Providers

SQL 2005 CE Provider 1 Beta Release - Upgrade

christopherglasater — Tue, 18 Sep 2007 22:44:08 GMT

This post is an enhancement from the code by JHEIDT:

http://community.codesmithtools.com/forums/p/5921/23086.aspx#23086

Basically I found the code that was provided was not recognized by the CodeSmith 4.1 Provider Schema API. I made modifications to the code..here are the results...

I had to change the namespace to allow the CodeSmith API to recognize the provider.

Oracle Schema provider

flash_us — Tue, 24 Jul 2007 00:39:36 GMT

The original version was made by Michael Toscano and Geoff McElhanon.

Now it is able to retrieve keys and fields information from Oracle. That meant much better working with NetTiers! The only file that isn't generated is the file with stored procedures. Hope guys from NetTiers will fix it soon.

Made by Ilya Dyachenko aka flash_us.

VistaDB 3.0 Schema Provider

JasonBunting — Fri, 02 Mar 2007 23:16:19 GMT

A CodeSmith SchemaProvider for VistaDB 3.0 is now available for download here.

Improved SQLite 3 Schema Provider

joseph_guadagno — Tue, 23 Jan 2007 18:05:13 GMT

This Schema Provider is based on the Schema Provider provided by Adam Nelson (anelson@apocryph.org) which can be found at http://community.codesmithtools.com/files/folders/schemaproviders/entry18263.aspx. If you have any questions or comments regarding this Schema Provider, contact me, Joseph Guadagno, at jguadagno@hotmail.com.

Improvements Made

Added a resource file for string constants, and messages.
Name property changed to use Reflection to return the name of the provider.
Description property changed to use a string from the resource file.
GetCommandParameters, GetCommandResultSchemas, and GetCommandText methods were changed to use the resource file for its string values.
GetTableColumns: This method was modified to return additional properties to the column, namely size, numeric scale, and precision.
GetTableKeys: This method was modified to return the ForeignKeys for the table as well as the tables that have a reference to the specified table. This is required by the SchemaExplorer interface to properly populate the PrimaryKey and ForiegnKey properties.
New File: SchemaColumns.cs: This file contains constants for all of the columns available for GetSchema calls.
Included a test client which provides an interface to test the provider.

Requirements for this SchemaProvider

SchemaExplorer.DLL version 3.2.7.955

System.Data.SQLite ADO.NET provider found at http://sourceforge.net/projects/sqlite-dotnet2

SQLite 3 alternative provider

dSquared — Wed, 27 Sep 2006 21:23:35 GMT

Here is an alternative schema provider for sqlite3 database.
Actually it is a corrected and enhanced version of the Apocryph one (http://apocryph.org/a_sqlite_schema_provider_for_codesmith), which use the very good sqlite ADO.net wrapper of http://sqlite.phxsoftware.com/.

What I've modified is :
- support of correct Native Types
- addition of the CS_Identity extended property.

ps: I use this provider along with .netTiers to generate a fully fonctionnal entities/dal layers. more on that on the .netTiers forums in few days.

Informix Schema Provider

sbaker — Wed, 26 Apr 2006 18:34:18 GMT

Custom schema provider for IBM Informix using the IBM Informix .NET Provider. Tested with Informix Client SDK version 2.9 and Informix Dynamic Server version 9.4. This schema provider was based on the MySQL provider created by David Neal at ChristianASP.NET.

Feel free to send any improvements to Sean Baker at sbaker@moneymailer.com.

Release 1.0.0.0 - 2006-04-26

Initial Release

MySQL 5.0 Schema Provider for CodeSmith 3.1.x

ChristianASPNET — Wed, 28 Dec 2005 21:11:57 GMT

Custom schema provider for MySQL 5.0. The provider takes advantage of the latest MySQL features, including INFORMATION_SCHEMA tables, stored procedures, and so forth.

Be sure to read the included readme.txt for instructions on requirements and how to set up the provider.

Release Notes

Release 0.9.2 : 2006-02-17

Updated GetTableKeys() to provide not only the foreign keys for the table but also the foreign keys of other tables that point to the given table. Updated code graciously provided by Douglas R. Steen. Thanks!
Added .NET 2.0 version for CodeSmith 3.2.5 or higher (unless recompiled)
.NET 1.1 version requires CodeSmith 3.1.6 (unless recompiled)

Release 0.9.1 : 2005-12-29

Added support for Extended Properties CS_IsIdentity
Bug fix for GetTableData()
Requires CodeSmith v3.1.4

Release 0.9.0 : 2005-11-27

Initial Release

DB2 Schema Provider

gmcelhanon — Wed, 21 Dec 2005 00:34:40 GMT

This is the location of the most up-to-date version of the unofficial DB2 Schema Provider for CodeSmith 3.x. This provider uses IBM's DB2 provider for .NET. Obviously, you will need to have the IBM DB2 client software installed prior to use.

The source and the compiled binary are attached in separate ZIP files to this message. To "install" the provider, just copy the following files (from the binaries zip) to your C:\Program Files\CodeSmith\v3.0\SchemaProviders (or equivalent) folder:

SchemaExplorer.Db2SchemaProvider.dll
SchemaExplorer.Db2SchemaProvider.dll.config

Many of the features available in the Oracle Schema Provider are available in this DB2 version since they share the same basic source code. Unfortunately, I don't have the time to fully document the specifics of this library. For example, many of the same CS_* extended properties are available, and there is support for the CODESMITH_EXTENDED_PROPERTIES table for use with your templates.

Also, the config file is simple and well documented. You should review this before actually using the provider just to know what options are available to you that control some of the provider's behavior.

Enjoy,
Geoff McElhanon

ADOXSchemaProvider Source Code

ejsmith — Tue, 20 Dec 2005 07:15:12 GMT

Here is the source code to the ADOXSchemaProvider. It can be used as an example of how to build a schema provider.

Oracle Schema Provider

gmcelhanon — Mon, 19 Dec 2005 19:57:25 GMT

This is the location of the most up-to-date version of the unofficial Oracle Schema Provider for CodeSmith. Thanks goes out to Michael Toscano (aka VikingCoder) for starting a new Oracle provider based solely on the System.Data.OracleClient namespace.

To "install" the provider, review the included readme.txt.

RANDOM NOTES:

The CommandSchema objects returned from the provider will now have the following properties:

CS_ObjectType (i.e "PACKAGE")
CS_Status (i.e. "VALID", "INVALID")
CS_ObjectId (OBJECT_ID of PACKAGE where command resides)
CS_OverloadNumber (will be -1 if no overload exists, or a number > 0 if overloads are present)
CS_FullName (will contain the original "raw" command name prefixed with the owner).
CS_Name (will contain the original "raw" command name)

To support overloads in Oracle, the provider reports the Command.Name property as CUSTOMER.MODIFY[1], CUSTOMER.MODIFY[2], and so on. What this means is that in order for you to write templates that will handle overloaded Oracle procedures correctly, you'll need to use the CS_Name extended property value of the CommandSchema object instead of the Name property.

I have added support for SQL Server-like extended properties through creation of a CODESMITH_EXTENDED_PROPERTIES table (which is automatically excluded from the list returned by GetTables, by the way). This is a very powerful feature and I have already started putting it to great use for allowing fine grained control of certain aspects of my PL/SQL generation process (i.e. defining lookup tables and columns, being able to exclude certain columns from all procedure signatures, like CREATEDATE and MODIFIEDDATE, and to provide defaults for those values when they're excluded). The possibilities are endless.

SQLite 3 SchemaProvider

pwelter34 — Mon, 19 Dec 2005 19:42:09 GMT

DESCRIPTION:

SQLiteSchemaProvider is a SQLite Version 3 schema provider for CodeSmith 3.0
using Finisar.SQLite ADO.NET Data Provider.

INSTALLATION:

Simply expand SQLiteSchemaProvider<version>.zip to your CodeSmith directory.
This is the directory which contains the CodeSmithStudio.exe executeable.

USAGE:

Use Schema Explorer in CodeSmith. When asks for a connection string, enter
a connection in this format:

Data Source=d:\temp\test.db3; Version=3

where 'Data Source' is the full path to your database and set 'Version' to 3.

REMARKS:

This will not work against version 2 databases. If enough people ask for it,
I can update the source. I will be releasing the source once I get some
feedback on its stability.

SQLite is practically typeless. The types declared in your SQL are hints to the
database as to the type of data that may be stored in the column. Types may be
omitted altogether. e.g. CREATE TABLE mytable (id, name) is valid SQLite SQL.
Even if you declare a column as INT, you may store a string into that column.

SQLite's manifest type typing system makes it difficult for code generation
since CodeSmith template authors rely on detailed metadata to generate
strongly typed code. To work around this, QLiteSchemaProvider uses type mapping
rules stored an XML file. Modify this configuration file for the types you use.
Please read the comments in SQLiteTypeMapping.XML which should have expanded
into the CodeSmith installation folder. It should work as is, but I don't know
what types you are using.

HISTORY:

0.0.1.0
-------
Initial release.