SQL 2005 CE Provider 1 Beta Release - Includes source

Hey everyone, I've seen a lot of demand for this provider on the forums, and needed it in a project myself. As of right now it's still in beta. Most of what you can actually do with SQL CE is included, but I have not wired up the .Keys (except .PrimaryKey), due to a lack of any relational data inside of CE yet. I assure you that I will eventually add the foreign key stuff, but right now I figured I'd release this version of the schema provider.

To add this to your codesmith installation, you are going to have to edit a config file in your application data/codesmith folder, there is more information about that process in other posts.

Hi evolved,

I want to try your sqlce provider but cannot figure out how to properly edit a config file in order to get that schema provider included with codesmith installation. Could you, please, post a more detailed explanation for that? 

Thanks. 

Search the forum, theres dedicated posts to this process (its what i did) 

Well i see tons of posts on the addin forum here asking why a schema provider isnt working. Here's the instructions I read on this forum just a few months ago (i cant find the post)

Goto: C:\Documents and Settings\<YOUR LOGIN>\Application Data\CodeSmith\v4.0,

edit SchemaExplorer.config, goto the  <schemaProviders> section, and add in the full name of your schema provider following the existing format, for this provider that format is:

<schemaProvider>JHeidt.CodeSmith.SchemaProviders.SqlCompactSchemaProvider, JHeidt.CodeSmith.SchemaProviders, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null</schemaProvider> 

Save. Open codesmith, if done correctly your schema provider should now show up in the drop down, if not - you've done something wrong, or the schema provider is busted.

Thanks for this post.  I'm running Vista and had to dig to find the file. 

 in case anyone else is looking for it...C:\Users\<Login>\AppData\Roaming\CodeSmith\v4.x