How do I use a database in Windows Mobile 6.5

Question

I am currently developing an application for a Motorola enterprise mobility device which has Windows Mobile 6.5. I am developing the application using Visual Studio 2008 Mobile Development Kit using C#.

My problem is this :

I want to use a database for this application. But I have no idea how to use a database in a mobile device. I tried googling and even searching on this site but could not find a proper way to do it. While searching how to do this I came across this "SQL Anywhere Developer Edition" but I have no idea about it.

Could you please suggest the best way to have a database in the mobile application itself (not using client like SQL Server in the mobile) or any other way.

Answer 1

You want Microsoft SQL Server Compact 3.5 for Windows Mobile.