create tables from xml schema (using C# & mssql)

Question

Im looking for ways to create data tables in mssql using a XML Schema file to specify the relationships/datatypes (for c#?).

Currently I know I can use the SQLXMLBulkLoadLib.

Also right now I am exploring the dataset.writexmlschema/dataset.readxmlschema, but I don't know very much on how this works for nested elements

Are there any other methods?

Alexander · Accepted Answer · 2013-04-11 19:26:07Z

1

Probably you can import xml schema into DataSet, and then recreate database structure using SQL Server Management Objects. There is an article on codeproject containing some samples on how to do this.

answered Apr 11, 2013 at 19:26

Alexander

4,1831 gold badge26 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tim Over a year ago

Yea I know about importing xml schema to dataset, but this does not seem to allow for me to nest multiple xml elements. It just doesn't seem to be flexible enough.

Collectives™ on Stack Overflow

create tables from xml schema (using C# & mssql)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related