Cross platform C# apps with SQLITE/SQL COMPACT Databases
When architecting a cross platform C# application (IE: planning on creating a mono version) what is the best path to take regarding the database implementation when using only local databases? Assume that in each of these implementations a practical separation of concerns exists.
A. Develop against SQL Compact and when porting to mono create an SQLITE version of the application?
B. Develop against SQLITE from the start?
C. Some other option?????
PS: Is there some specific reason/feature that one might prefer in either database implementation?
Why not develop for SQLite from the start? It's available for Windows, Linux and Mac OS X and you don't need to change anything from one platform to another this way. There's a Mono.Data.SqliteClient assembly if you need it.