Windows Mobile local database

Question

Hi,

I'm writing an application for windows mobile 6 and above that requires a local database.

I was wondering if anyone has any experience with database hosting on windows mobile and which database management system would be most suitable for development.

Thanks in advance,

Lloyd

Answer 1

SQL Server Compact Edition is widely used in Windows Mobile applications.

Another alternative is SQLite.

Answer 2

I have used SqlServerCe as a local mini database for a WinMobile 6 application I've worked on. It is quite easy to use and gets automatically installed when you include the reference in Visual Studio.

Another option that seems popular is SQLite. For a comparison of the two look at this post: http://stackoverflow.com/questions/583278/sqlite-vs-sqlce-vs-in-a-mobile-application This seems to be biased towards SQLite which I have not tried but I was happy with the performance of SqlServerCe for my application and it was sufficient.

Answer 3

Hi,

If you are not tied to RDBMS, you should try db4o, an embedded object oriented database with support for LINQ

Answer 4

I've used for some small applications Raima Database, and it proved to be reliable and fast, at least for our purposes.