ADO.NET

Windows application for comparing efficiency of using XML and Access files in ADO.NET

• Scenario of using application:
  • Ask user for the name of XML file
    • Read schema and all data from the file
  • Create database in Access format with the same schema
    • Make sure to apply all relations and keys
    • Save all data read from the XML file
  • Show form with a datagrid presenting all the data (use whole dataset as a source of data)
  • Ask user about the number of random data to add to all tables (it can be huge number)
    • Add random data to all tables
    • Make sure that consistency of data will not be corrupted (constraints of primary and foreign keys)
  • Measure times of writing data to Access file and to XML file
    • Show results (in simple message box)
• Hints:
  • Use datasets
  • How to create Access database using ADO.NET
  • How to use SQL in Access
• Approximate points:
  • read XML: 0.5
  • create Access database: 3.5
  • save data to Access database: 0.5
  • form with a datagrid: 1.0
  • add random data to tables: 3.5
  • measure times of saving data to Access and XML files: 1.0