I have a remote xml that resides on a URI like this "http://www.server.com/xmlFile.xml"
The structure of the xml is heirarchical forming 1:M table relation like:
Expand|Select|Wrap|Line Numbers
- <Data>
- <Department>
- <ID>1</ID>
- <Name>Accounting</Name>
- <Employee>
- <ID>1</ID>
- <Name>John Smith</Name>
- </Employee>
- </Department>
- </Data>
Now I need to import this data to sql server, where I have two tables one for Departments and the other for Employees and a relation exists between the tables.
I tried to use dataset.readxml method but failed to accomplish the result...
what is the best practices knowing that the xml is quite large and this is a web application that needs performance to be taken in consideration..
thanks in advance :|