This is a patch adding mysql support to nettiers. It uses the GenericClient with a MySQL specific xml file. The patch basically adds the xml file, adds support for unsigned types, and removes the hardcoded SQLite association with the GenericClient. All unit tests pass against the sql northwind db and our MySQL Db.
I made a few GenericClient changes and because of this, SQLite support is probably broken. I was able to get a project generated against an SQLite DB, but it wouldn't build. I had the same problem as this post: http://community.codesmithtools.com/forums/p/6761/25990.aspx#25990 which leads me to believe it has nothing to do with what I changed. I would really like someone who knows SQLite and who has it working with nettiers to try this patch and, at the very least, let me know how it goes. I am assuming not very many folks are using SQLite as I had to update the SQL3SchemaProvider (from the downloads section) to use it with the newest codesmith version. Anyway, there are a couple of things I _know_ are broken in SQLite, such as <table>_Find query.
If anyone has an SQLite db that is reasonably complex and works with nettiers, I would love to get my hands on it. Or if you are a nettiers/sqlite ninja, help getting it all up and running would be appreciated.
Oh, and more MySQL testers with diverse schemas are welcome to try this out! :)
Ben