Implement the SQLite provider for people who don't have MSSQL

[GoogleCodeExporter]

Sprocket should support the SQLite provider
(http://sqlite.phxsoftware.com/) for those not using sql server. Seeing as
the actual database requirements of the core sprocket engine are still very
minimal, this will be an opportunity to:
(a) use a factory pattern to separate the database operations from the
actual providers. i.e. a facade class which instantiates a database
procedures class that is selected based on a supplied SqlDatabaseType
enumerated constant. This way it becomes a simple matter to extend all
database-using modules with additional database support.
(b) Update the class generator to support generation of the different types
(c) Update the horrible bit of code surrounding DefaultSecurityProvider
(d) Create an interface for the security provider; update all references to
the SecurityProvider class so that they reference ISprocketSecurityProvider

Original issue reported on code.google.com by SnowDe...@gmail.com on 31 Aug 2006 at 7:22

[GoogleCodeExporter]

All the database and core level overhaul work has been done. SQLite versions of 
the
existing database functionality is not yet finished.

Original comment by SnowDe...@gmail.com on 12 Dec 2006 at 11:31

• Changed state: Started

[GoogleCodeExporter]

done.

Original comment by SnowDe...@gmail.com on 5 Sep 2007 at 12:15

• Changed state: Fixed