Database for small application

  • Thread starter Thread starter Rudolf Ziegaus
  • Start date Start date
R

Rudolf Ziegaus

Hi,

to get started with .NET and the compact framework I'd like to write a small application for my private use - a vocabulary trainer
to support my spanish classes.

I'd like to e able to use it on my PC and on my PDA, so the data should be exchangable.
What would be the best way to store the data?

What about the SQL Server Mobile? Wouldn't that be a bit oversized for my small application?
I think I won't have much more than several thousand entries.
Would you recommend me using the SQL Server Mobile? What about the cost?

Are there any alternatives you could recommend to me?


Thanks,


Rudi
 
Sql Mobile is the easiest to work with in that you have all the tools
required included with Visual Studio. It's free to use as a standalone
database. With SQL Everywhere you can use the same database on a desktop
machine also -
http://blogs.msdn.com/stevelasker/archive/2006/04/10/SqlEverywhereInfo.aspx.

If you were to synchronise with a SQL Server backend then you would need a
client SQL Server license, but I doubt this applies in your scenario.

Peter
 
Am Sun, 30 Apr 2006 18:57:15 +0100 schrieb Peter Foot [MVP]:
Sql Mobile is the easiest to work with in that you have all the tools
required included with Visual Studio. It's free to use as a standalone
database. With SQL Everywhere you can use the same database on a desktop
machine also -
http://blogs.msdn.com/stevelasker/archive/2006/04/10/SqlEverywhereInfo.aspx.

If you were to synchronise with a SQL Server backend then you would need a
client SQL Server license, but I doubt this applies in your scenario.

Peter
Click to expand...

Hallo Peter,

thanks for your info.

As far as I understand SQL Mobile is included in Visual Studio Standard
Edition or above, but not in Visual Studio Express. Is this correct?

Thanks,

Rudi
 
None of the express editions support smart device development at all, so you
can't use SQL Mobile since you can't create a device application.

-Chris
 
Am Sun, 30 Apr 2006 16:41:50 -0400 schrieb Ginny Caughey [MVP]:
Rudolf,

It's correct that your need VS 2005 Standard or above.
Click to expand...

Ginny,

thanks for your confirmation.

Rudi
 
I use SQL Mobile for a while but it was so slow that my app crawled. I
swapped over to SQLite and my app is now much faster and uses less disk
space. Apparently the files are also binary compatible between PDA and
Desktop, so you should be able to just sync the DB file.
 
Am Mon, 1 May 2006 09:21:40 +0100 schrieb Peter Morris [Droopy eyes
software]:
I use SQL Mobile for a while but it was so slow that my app crawled. I
swapped over to SQLite and my app is now much faster and uses less disk
space. Apparently the files are also binary compatible between PDA and
Desktop, so you should be able to just sync the DB file.
Click to expand...

Thanks Peter,


that's something I will definitely try it. This is the kind of tool I have
been looking for.

Rudi
 
Back
Top