RE: SQLite 3 Schema Provider

Hi All,

I created this SchemaProvider for SQLite 3. I've only used in on a few templates, so please try it. This will not work with SQLite 2 version databases. If there is enough interest, I will try to make it compatible. In any case, I will release this as open source once I get some feedback on its stability/accuracy.

Does anyone have a template that fully utilizies all the possible properties of a database schema? I've noticed that some templates rely on extended properties. A comprehensive template would really be useful in testing custom providers. I would appreciate it.

Enjoy. Please read the SchemaProviders\SQLiteSchemaProvider-readme.txt.

Thanks!!

I was hoping somebody would create a provider for SQLite. I will test it as much as I can. Again, thanks for your work!

Ok, maybe I'm the only one of the 45 people that have downloaded it that can't get it to work, but I downloaded it, extracted it into my CodeSmith directory, but I still don't see it in the schema explorer. Is there something I am doing wrong, or a way to log it and see why it isn't working?

Hi Aaron,

I've been working on other open source stuff and just saw this post. That's all you should have to do to install it. I'm not sure if CodeSmith has any kind of tracing when it tries to load a plugin. Which version of CodeSmith are you running? I built against 3.1.4.481. I'll package up the source and provide instructions how to build it. Should be up in the next day or two.

I just noticed I am using 3.0.8.  I will upgrade to 3.1.4 and try that.

Can you post the source, or at least email it to me, so I can compile against 316 also?

SUCCESS!!  3.1.4 works (Yeah!!).  Nice job, it looks like a great provider. 

However, if there are Foreign Key contraints defined, they don't seem to show up in the provider.  I know that SQLite doesn't ENFORCE the FK's, but I use the info in them to enable foreign key mapping in my templates.  Is this not handled? 

I just posted an alternative SQLite 3 provider here

It uses the SQLite.NET API, is available for .NET 2.0 only, and exposes foreign key information as well as tables and views, so complex OR mapping templates should work.

Adam