Windows Mobile local database [closed]

开发者_StackOverflow As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. Closed 10 years ago.

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

---

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: https://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.

---

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

Another alternative is SQLite.

---

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

---

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