E
Enver A
I am using SQLCE Server databases *.SDF
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Brett Miller
G
Ginny Caughey [MVP]
Jan,
Unless the amount of data you will be working with is very small, I would
definitely recommend SqlCe instead of XML.
--
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
Unless the amount of data you will be working with is very small, I would
definitely recommend SqlCe instead of XML.
--
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
G
Ginny Caughey [MVP]
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
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
E
Eric
which database is availible (if any) for the PocketPC? Or is it better
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.
to use XML?
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.
J
Jamie Macleod
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
they don't have all the tags so they are smaller.
Jamie
E
Enrico Pavesi
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
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
B
Boris Nienke
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)
do you know the price for the .Net version (for CF of course)?
Boris
G
Ginny Caughey [MVP]
Hi Jamie,
No I'd also use CSV rather than XML since it is quite a bit faster and just
as easy to use with the OpenNetCF.org data adapter.
--
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
No I'd also use CSV rather than XML since it is quite a bit faster and just
as easy to use with the OpenNetCF.org data adapter.
--
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
G
Ginny Caughey [MVP]
Boris,
I have also used Codebase with good results (the files are DBF files like
Foxpro), but I haven't used the .Net version.
--
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
I have also used Codebase with good results (the files are DBF files like
Foxpro), but I haven't used the .Net version.
--
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
J
Jamie Macleod
Hi Ginny,
For those interested, I changed the CSVDataAdapter to allow for another
header line. The second line contains the data type of each column. I
changed the namespace so it wouldn't conflict with the original version.
It's not well tested, but I am using it with no problem so far.
http://www3.telus.net/spaw/dotnet/SouthpawCSVDataAdapter.zip
Jamie
For those interested, I changed the CSVDataAdapter to allow for another
header line. The second line contains the data type of each column. I
changed the namespace so it wouldn't conflict with the original version.
It's not well tested, but I am using it with no problem so far.
http://www3.telus.net/spaw/dotnet/SouthpawCSVDataAdapter.zip
Jamie
J
Jay
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.
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.
G
Ginny Caughey [MVP]
Thanks, Jamie. That sounds like a nice enhancement. I'll check it out.
--
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
--
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
E
Enrico Pavesi
I think is around 300 Euros (no runtime fees)
Enrico
Enrico
J
Jay
Still I would suggest using webservices and DataSet.
J
Jacky
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
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
J
Jay
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.
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.
J
Jacky
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
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
J
Joe Keller
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
I've found CSV files multiple times faster than either XML and SQLCE and
much easier to implement with a lot less overhead.
Joe
G
Ginny Caughey [MVP]
Thanks for the feedback, Joe. How many records were you working with?
--
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
--
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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.