Choosing a database for Windows Phone 7 Application
Posted on 2011-09-05
I am attempting to create a mobile application for a Window Phone 7 and need to figure out what databases are available, it will be used in the field to record damage on particular assets e.g. a road. On finding a site the user will record textual details and have buttons that will create either point or poly-line objects, one or the other, the data from this is going to hopefully come from the GPS. So there needs to be a spatial element to the database.
The application will not be showing a map at all, it will just be recording one spatial object per record. The spatial object is only there so later in the office people can map it.
I am using Silverlight in MS Visual Studio 2010 Express for Windows Phone
I know that SyBase Ultralite would be a good fit, however most clients use MapInfo and ESRI and I'm not sure how easy it is to open this format.
The other is SQL Server Express 2008, which is handy cause it would be free, and I know MapInfo and ESRI support this. However, is it too big to be on a window phone 7?
I am only going to have 4-5 tables in the database and if the total number of records goes beyond 3000 I will be surprised.
Has anyone tried something like this? Any advice would be appreciated!