Sunday, February 1, 2009

SQL Compact 3.5 Schema Provider for CodeSmith now available

I have modified, improved and updated the existing SQL Compact 2005 CodeSmith Schema Provider. It is available here: http://community.codesmithtools.com/forums/p/9303/34491.aspx#34491

New/enhanced features include:

GetDatabaseName:
Now returns the sdf file name without extension

GetTableColumns:
Support for all 3.5 data types, including rowversion
Excludes system columns
Several extended properties added

GetTableIndexes:
Bug fix for same index name on different tables

GetTableKeys:
Added - gets all foreign keys

GetTablePrimaryKey:
Bug fix for returning not only primary keys.

GetTables:
Excludes system tables

Tested with Nettiers 2.3.b2 (with a slightly modified Nettiers.cst).

The Schema Provider in action:

image 

Technorati Tags: ,,

No comments: