SQL compact or XML?

[mrabie]

Hi,

I am developing an application that requires storing of data, i first
started out with using XML and DataSet as my dbase but i figured out i
need to run several quiries and return certain data set, which can't
be done using XML and that the data might get big by time and loading
the whole file in memory will cz problems especially performace. So i
decided to try out SQL compact.

Here's my problem, if i am using SQL 3.5 to develop my app does my
users have to deploy it on their devices, or can i just add the DLL
files to my project (or cab file) and would work?

Thanks for your help

 

[Christian Resma Helle]

Most people would say that you would have to deploy SQL CE 3.5 to the
device.

But it's possible to get it to work having only the managed wrapper
(System.Data.SqlServerCe.dll), managed extensions (sqlceme35.dll) and the
query processor (sqlceqp35.dll) in the applications working directory or in
the windows directory.

I would stay away from using XML as your datastore. You would get very very
poor performance. There are alot of data access performance optimization
articles for sql ce out there. You should check them out.

 

[Guest]

SQL CE comes fully unpackaged with the SDK and doesn't require a GAC
install, so deploy the DLLs with your app.


--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Giving back to the embedded community
http://community.OpenNETCF.com

 

[mrabie]

SQL CE comes fully unpackaged with the SDK and doesn't require a GAC
install, so deploy the DLLs with your app.

--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Giving back to the embedded communityhttp://community.OpenNETCF.com









- Show quoted text -

gr8 guys thanks... another question.. how can i change the deploy
location of the database from VS2008 when i want to run the
application on the emulator? i want to place the database and the DLLs
in the windows directory.

thanks appreciate it

 

[Guest]

The only workable way to do it is to add another project to your solution
and put the SQL CE files in it (even just as linked files) then set them to
copy if newer and set the project's deploy folder.


--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Giving back to the embedded community
http://community.OpenNETCF.com

SQL CE comes fully unpackaged with the SDK and doesn't require a GAC
install, so deploy the DLLs with your app.

--

Chris Tacke, Embedded MVP
OpenNETCF Consulting
Giving back to the embedded communityhttp://community.OpenNETCF.com









- Show quoted text -

gr8 guys thanks... another question.. how can i change the deploy
location of the database from VS2008 when i want to run the
application on the emulator? i want to place the database and the DLLs
in the windows directory.

thanks appreciate it