Compact .NET & database?

  • Thread starter Thread starter Enver A
  • Start date Start date
Jan,

There is no charge for SqlCe. If the SqlCe database connects to a SqlServer
database, then you need CALs (or per-processor licensing) for the SqlServer
however.

But if the amount of data is tiny, XML might be almost as easy to work with
since it's easy to read/write to a DataSet. I'd suggest making little tests
with both approaches and see which you like better.

--
Ginny Caughey
..Net Compact Framework MVP

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups
 
which database is availible (if any) for the PocketPC? Or is it better
to use XML?
Click to expand...

If you can, use SQL (MSDE). If you don't need the data locally, either
directly connecting or making a web service works great.

If you use MSDE, it's free.
 
Would you use XML over CSV text files? I find CSV files really fast and
they don't have all the tags so they are smaller.

Jamie
 
Give a try to CodeBase.
You pay 1 time and use forever.

Is an ISAM library (with some relational features).
The speed is amazing and file are DBF (portable with no conversion)

Enrico
 
Give a try to CodeBase.
You pay 1 time and use forever.

Is an ISAM library (with some relational features).
The speed is amazing and file are DBF (portable with no conversion)
Click to expand...

do you know the price for the .Net version (for CF of course)?

Boris
 
Jan,
What is your database of choice on the desktop to sync to?


If it is SqlServer/MSDE I would just use SQL CE. If it is MS Access then
best approach would be to use, MS Access/WebService/DataSet.

Sync takes me less than a minute for 1000 records.
Jay.
 
Hello,
I try both XML and SQLCE and choose SQLCE.
XML/Dataset transformations are very slow (perhaps it's better now with SP2
(?))

Jay, did you see some performance problems with webservices ?
The first call of the WS is very, very slow ...
DataSet are very big objects .. I think that they should be replaced with
array of strings ..

bye
JJ
 
Jacky,

I was reading some where to not set the schema/primary key. If you dont set
schema DataSet just becomes array of strings.
I have 1000 records synced under a minute which is fine with me.
jay.
 
OK,
can you send me the URL if you remember it ?
It seems to be strange because DataSet is a big object, even without
schema...
bye
Jacky
 
For what it's worth, I've implemented both SQLCE, XML, and CSV files and
I've found CSV files multiple times faster than either XML and SQLCE and
much easier to implement with a lot less overhead.

Joe
 
Back
Top