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?

Answers


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.


Need Your Help

How to display the text in particular direction(swipe direction) from particular point in android

android textview android-edittext

I want to display the text on image in selected touch portion and should be in direction where we swipe. Need to launch the EditText to enter the text.

How to change Image src for Multiple Images

javascript jquery html css

I have some images on my page, but they're all the same image. I'd like to know how I can change them all with jQuery. Below is what I currently have setup.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.