XML to SDF

[a_ve_m]

I want to insert XML data into SDF. i did it in mobile.But it take
too long time. For that i want do it in PC. but i must use SQl
Server CE 2.0 file ,Because in my device-Casio 3000M53E there is
windows ce 4.1.NET. Thats why i should use SQl Server CE 2.0 version.
Please help me.

 

[a_ve_m]

What are you thinking about if i ll do this from txt file ?

ohh i did it from txt file,its too take too long time again...
what to do

 

[Ginny Caughey MVP]

Have you tried the TextDataReader on OpenNETCF.com? How large a file are you
attempting to use? Did you try the Primeworks library? I believe there's a
free eval version so you could see if it meets your needs.

--

Ginny Caughey
Device Application Development MVP

What are you thinking about if i ll do this from txt file ?

ohh i did it from txt file,its too take too long time again...
what to do

 

[a_ve_m]

Thanx for your answer
i want to insert into table about 1000-1500 rows. its in XML about 250
kb, in txt fomat about 70 kb,
i researched in primeworks ,but not found anything.
ok I'll try it again. if its not useful, ill try TextDataReader on
OpenNETCF.com
again thanks for your help

 

[Simon Hart [MVP]]

Why don't you upgrade to SQL CE 3.5 then you can perform the work on the
desktop which will run pretty much instantly then send the SDF to the device
using the device version of SQL Server CE? 3.5 is supported on 2003.

 

[Simon Hart [MVP]]

Version 2.0 of SQL CE doesn't exist for desktop. This was introduced in
v3.1.

 

[a_ve_m]

Thanks for answer Simon
i tried ce 3.5 but there were problem wehen i install it to mobile
device
is ce 3.5 work in windows ce 4.1 ? framework 1.
Araz

 

[Ginny Caughey MVP]

If your source file could be CSV rather than XML, I believe you could
improve the parsing speed by about 100% with CF version 1. XML parsing was
much improved in CF 2.

--

Ginny Caughey
Device Application Development MVP


Thanx for your answer
i want to insert into table about 1000-1500 rows. its in XML about 250
kb, in txt fomat about 70 kb,
i researched in primeworks ,but not found anything.
ok I'll try it again. if its not useful, ill try TextDataReader on
OpenNETCF.com
again thanks for your help

 

[a_ve_m]

Thanks for answer Simon
i tried ce 3.5 but there were problem wehen i install it to mobile
device
is ce 3.5 work in windows ce 4.1 ? framework 1.
Araz

when i install ce 3.5 there was an error "Please install .net 2.0 or
3.0 0r 3.5 " and then i tried to install .net 2.0 compact framework.
and here occurred a problem "program is not compatible for windows"
what to
i cant install ce 3.0 or ce 3.5

 

[a_ve_m]

Thanx a lot
i'll try it

If your source file could be CSV rather than XML, I believe you could
improve the parsing speed by about 100% with CF version 1. XML parsing was
much improved in CF 2.

--

Ginny Caughey
Device Application Development MVP


Thanx for your answer
i want to insert into table about 1000-1500 rows. its in XML about 250
kb, in txt fomat about 70 kb,
i researched in primeworks ,but not found anything.
ok I'll try it again. if its not useful, ill try TextDataReader on
OpenNETCF.com
again thanks for your help

 

[a_ve_m]

Thanx a lot
i'll try it

so i tried all way but there is no improvement
so i tried primework library too
moderator of the this sites form Paul said me there is not desktop
SQL CE 2.0 databases cannot be opened from the desktop
thanx to all for your help
the problem not solved yet (((((

 

[a_ve_m]

Thanx a lot
i'll try it

so i tried all way but there is no improvement
so i tried primework library too
moderator of the this sites form Paul said me there is not desktop
SQL CE 2.0 databases cannot be opened from the desktop
thanx to all for your help
the problem not solved yet (((((

 

[Ginny Caughey MVP]

If you get exactly the same performance using CSV files compared with XML on
CF 1, then I really don't have any suggestions for you. You are using
technology that is so old that most of us no longer even have it around to
test on. Given that, I think you'll just have to be satisfied with the
performance you have unless you are able to upgrade.

--

Ginny Caughey
Device Application Development MVP

Thanx a lot
i'll try it

so i tried all way but there is no improvement
so i tried primework library too
moderator of the this sites form Paul said me there is not desktop
SQL CE 2.0 databases cannot be opened from the desktop
thanx to all for your help
the problem not solved yet (((((

 

[a_ve_m]

ITS unbelievable i can install into 4.1 ce 3.5 and there are every
component in 3.5
thanx MICROSOFT

 

[a_ve_m]

ITS unbelievable i can install into 4.1 ce 3.5 and there are every
component in 3.5
thanx MICROSOFT

 

[a_ve_m]

ITS unbelievable i can install into 4.1 ce 3.5 and there are every
component in 3.5
thanx MICROSOFT

 

[a_ve_m]

i created 3.5 .sdf file in win ce 4.1 and then i copied it to my PC
then i added table, column and some rows,
then i copied it to mobile
and i can open it with Visual Studio 2008 Desktop
very interesting ce 3.0 not worked in ce4.1 but 3.5 worked
Again thanks to all for your help

Best Regards ,
Araz Mustafa

 

[Ginny Caughey MVP]

Thanks for reporting back, Araz. I wouldn't have expected that to work
either, and I no longer have any 4.1 devices to test with. CE 3.0 isn't
supposed to work on the desktop (except for dev machines and TabletPCs).
Which version of the Compact Framework are you using with CE 4.1?

--

Ginny Caughey
Device Application Development MVP


i created 3.5 .sdf file in win ce 4.1 and then i copied it to my PC
then i added table, column and some rows,
then i copied it to mobile
and i can open it with Visual Studio 2008 Desktop
very interesting ce 3.0 not worked in ce4.1 but 3.5 worked
Again thanks to all for your help

Best Regards ,
Araz Mustafa

 

[a_ve_m]

when i copied 3.5 sdf to desktop VS 2005 not opened this file
. then i installed vs 2008 its opened

i use .net cf 1.0. and when i install ce 3.5 i used this files:

sqlce.dev.ENU.ppc.wce4.armv4.CAB
sqlce.repl.ppc.wce4.armv4.CAB
sqlce.ppc.wce4.armv4.CAB
sqlceca35.dll
sqlcecompact35.dll
sqlceer35EN.dll
sqlceme35.dll
sqlceoledb35.dll
sqlceqp35.dll
sqlcese35.dll

what are you thinking about it how can i develop applcs to connect 3.5
sdf .
when i tried application which developed for ce 2.0 error occurred
"Missing Method Exception"

 

[Ginny Caughey MVP]

You need at least Compact Framework ver. 2 to work with SQL CE 3.5. I don't
know if you would be able to install CF ver. 2 on your device, but I don't
think it is supported on CE 4.1. It would be nice if this would work for
you, because then you could create the sdf file on the desktop and just copy
it to the device. You would need to remove the references to SQL CE 2 from
your app and replace them with references to SQL CE 3.5. But if CF 2 doesn't
run on your device, then this isn't an option for you with that device.

VS 2005 works with SQL CE 3.0 and 3.1, and VS 2008 works with SQL CE 3.5.

--

Ginny Caughey
Device Application Development MVP


when i copied 3.5 sdf to desktop VS 2005 not opened this file
.. then i installed vs 2008 its opened

i use .net cf 1.0. and when i install ce 3.5 i used this files:

sqlce.dev.ENU.ppc.wce4.armv4.CAB
sqlce.repl.ppc.wce4.armv4.CAB
sqlce.ppc.wce4.armv4.CAB
sqlceca35.dll
sqlcecompact35.dll
sqlceer35EN.dll
sqlceme35.dll
sqlceoledb35.dll
sqlceqp35.dll
sqlcese35.dll

what are you thinking about it how can i develop applcs to connect 3.5
sdf .
when i tried application which developed for ce 2.0 error occurred
"Missing Method Exception"