SQL XML Bulk Load

[Shane]

Hi All,

I have used the above functionality to generate tables from XML using
standard SQL Server 2000. However , as far as I can make out , I can't
use SQL XML Bulk Load in the compact framework unless I write a
wrapper.

Does this make sense to anyone or am I missing out on something?

If I can't make use of SQL XML Bulk Load can any one suggest any SQL
Server CE functionality I can access via C# that will enable
relatively simple generation of Tables on SQL Server CE on a PDA ?

Thanks in advance,
Shane

 

[Alex Feinman [MVP]]

If you create a web service that returns a dataset with data, you could
store this dataset data in the existing table. A code sample is available
here (it reads dataset from disk, but of course this does not change
anything): http://www.alexfeinman.com/download.asp?doc=ImportDataset.zip
As for creating a table from a dataset schema - I've done this, but don't
have a public sample. The process is not very complicated though.

 

[Shane]

As for creating a table from a dataset schema - I've done this, but don't

have a public sample. The process is not very complicated though.

Any hints as to what this process might be ?

Shane

 

[Roberto M. Oliva]

I've done it too... and the process is based on create an SQL Create Table
statement based on the DataColumns information of the DataTable contained on
the DataSet.
It's not complicated as Alex said.

Hope This Helps!
Roberto

 

[Alex Feinman [MVP]]

I've put together a sample for you. It not bulletproof, but you can use it
as a base for your code. Since some of the field information is lost during
DataSet population via DataAdapter, you may get better results by building
your own column descriptors and passing them to the CF code.

http://www.alexfeinman.com/download.asp?doc=XmlBulkLoad.zip

HTH

Alex