Supported database types

Since the actual version of SQLite (actually it is the .NET wrapper) has some value conversions issues and i'm waiting for the next release, which should come soon, i'm thinking about a feature that i had already half implemented but then put on ice.

The initial idea was to let XDB2 be able to use different database types. The first that came to my mind where SQLite (obviously), MS JET (Access database) and MS SQL Server.

Since i had some major issues with JET and SQL Server i had to skip them.
Now that i'm forced to look elsewhere i don't find them attractive anymore.
Access databases are not very .NET friendly and SQL Server is quite different from the main concept of XDB2 (single file, direct access to the file).
While it would be still very interesting to implement SQL Server support, i think i will drop JET support and rather will look elsewhere for an alternative to SQLite.

Recently i red about a rather new MS SQL Server type, SQL Server Compact. It seems that it is a single-file, zero-configuration database type like SQLite, so it would be a perfect candidate.

In the end i think i will implement (try) support for the three following databases:
- SQLite
- SQL Server Compact
- SQL Server (Will see if this is possible)

Other formats may be supported later when i'll work on export/import functions.