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:
Now returns the sdf file name without extension
Support for all 3.5 data types, including rowversion
Excludes system columns
Several extended properties added
Bug fix for same index name on different tables
Added - gets all foreign keys
Bug fix for returning not only primary keys.
Excludes system tables
Tested with Nettiers 2.3.b2 (with a slightly modified Nettiers.cst).
The Schema Provider in action: