Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 601
  • Last Modified:

Choosing a database for Windows Phone 7 Application

Hi,
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!
Hayden
0
AssetFX
Asked:
AssetFX
  • 4
  • 3
1 Solution
 
Andrei FomitchevCommented:
Try SQLite - it is free and lite and can work as on disk as in memory.

http://www.sqlite.org/download.html
0
 
Éric MoreauSenior .Net ConsultantCommented:
the mango update brings a database with it
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
AssetFXAuthor Commented:
Do both the Mango Local DB and SQLite allow for spatial data?
0
 
Éric MoreauSenior .Net ConsultantCommented:
not sure that the mango db will be as advanded as spatial data!
0
 
AssetFXAuthor Commented:
So I believe I will continue with the idea of SQLite, actually SpatiaLite. I will start creating a database shortly.

I have done a couple of tutorials with 'Microsoft Visual Studio 2010 Express with Windows Phone', Silverlight, and creating a small app with the Local database. Tutorial

Now I am just wondering, comparing against the tutorial and instead using a SpatiaLite database what differences I will come against when creating the connection and ViewModel?
0
 
AssetFXAuthor Commented:
But then thinking about it the tutorial was for a local database and I'm talking about external database. Do stop focusing on what the tutorial said and look at web services???
0
 
AssetFXAuthor Commented:
Although I found the solution through this answer I found the entire solution myself.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now