Efficiency

Question: Is the import of data from an XML file into a database efficient? If not, can you imagine an alternative solution?

Answer: A DataSet can be regarded as an in memory representation of XML data and its schema. A DataSet can be used to read the XML file and to store the data in different data sources. However, modern database servers directly support the manipulation of XML data, which is more efficient than the import via a DataSet.