In my spare time here in Baghdad I’ve been playing around more with SQLite, my favorite lightweight open-source database engine. I wanted to generate some data access objects using CodeSmith, but unfortunately CodeSmith can’t use the generic GetSchema() functionality in ADO.NET 2.0.

Instead, CodeSmith has its own chinsy provider model to expose schema information from a database system for the purposes of code generation based on that schema. It ships with SQL Server and ADOX support, and leaves the remaining database systems as exercises to an intrepid reader.