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.