What Database can use in cellphone

[morkie]

My classmate create a program using vb.net and
they told me java is good to use in cellphone...

My question is what is the good Database i can use in cellphone....

[jmcilhinney]

Particularly if you're creating .NET apps for Windows Mobile, SQL Server CE is a good choice for a database. It integrates with VS so it's the easiest to work with and it's designed with mobile devices in mind.

[GaryMazzone]

If using .Net then SQL CE

[morkie]

what is SQL CE?


and is .net can applied into mobile?, my classmate told me that we will convert it into java

[jmcilhinney]

what is SQL CE?

What is Google?

[morkie]

hahaha...

[gep13]

Hey,

SQL Server CE is SQL Server Compact Edition:

http://www.microsoft.com/Sqlserver/2...s/compact.aspx

Also, what sort of Mobile are you using?

Maybe this thread should be moved to the Mobile Development Forum?

Gary

[morkie]

so that's means SQL CE is the one the best i can use in windows mobile application....
any other database can be consider it to mobile application....

[gep13]

Hey,

You could always have an Access Database, but I personally wouldn't recommend that approach.

You could also just have an XML file.

But personally, I would use a SQL Server Compact Edition Database. It gives you so many options, in terms of Merge Replication with a backend database etc.

Gary

[si_the_geek]

Maybe this thread should be moved to the Mobile Development Forum?

Indeed it should - thread moved.

(thanks for letting us know )

[morkie]

sorry i post a wrong section....
Anyway thanks for your help....

[jdiperla]

I've been kind of looking around the forums and the web. Is SQL Server CE usable as a local DB? I am trying to create a sports simulator and need a database for players, etc...

And I can't seem to get a straight answer. So basically what I am asking for is this:

Can a SQL Server CE DB be used as a local file on the mobile device and have vb.net access it?

[gep13]

Short answer....

Yes.

Slightly longer answer...

SQL Server Compact Edition creates an SDF file, which you will need to deploy to your mobile device, and from there you can access it.

Gary

[jdiperla]

Awesome! Thanks. One other question... This SDF file can be accessed from VB.NET and it wont need a local SQL CE Server to be running on the device? It wouldn't need other dependencies?

[gep13]

Hey,

You don't get a SQL Server CE instance, there are only a couple DLL files that you need to deploy to the mobile device.

Gary

[jdiperla]

Cool. Thanks for the info and help.

[gep13]

For more information, you might want to take a look at the following:

http://www.christec.co.nz/blog/archives/253

and here:

http://channel9.msdn.com/posts/Steve...mpact-Edition/

Gary

[jmcilhinney]

I've been kind of looking around the forums and the web. Is SQL Server CE usable as a local DB? I am trying to create a sports simulator and need a database for players, etc...

And I can't seem to get a straight answer. So basically what I am asking for is this:

Can a SQL Server CE DB be used as a local file on the mobile device and have vb.net access it?

You probably should have read this thread before asking a question that's already been answered. From post #2:

Particularly if you're creating .NET apps for Windows Mobile, SQL Server CE is a good choice for a database.