c# Import/export XML to/from relational database

Write 2 classes in c# to export a record set (TableType or ChartType) from relational database (Access) to XML file, and import this XML file back into the relational database. The ChartType contains a binary file, which is stored in the database. See detailed description for the TableType and the ChartType. ## Deliverables Attached you can find the Access database containg TableTypes and ChartTypes: TableTypes are build from table "TableProfiles", which links to table "TableStyles" by field "table_style_id" (1-1), which in turn links to the records (1-many) in TableAreas with the same "table_style_id" The XML file for TableType "ORTableStyle1" could look like this: <?xml version="1.0" encoding="UTF-8"?> <TableProfiles> <layout_name>ORTableStyle1</layout_name> <TableStyles> <name>Blue</name> <TableAreas> <table_area_id>2</table_area_id> <typeface>Arial</typeface> <typeface_size>9</typeface_size> <typeface_style>700</typeface_style> <typeface_color>0</typeface_color> <cell_color>14607331</cell_color> <justification>2</justification> <angle>0</angle> <nof_decimals>0</nof_decimals> <new>1</new> </TableAreas> <TableAreas> <table_area_id>50</table_area_id> <typeface>Arial</typeface> <typeface_size>9</typeface_size> <typeface_style>400</typeface_style> <typeface_color>0</typeface_color> <cell_color>2364074</cell_color> <justification>11</justification> <angle>0</angle> <nof_decimals>0</nof_decimals> <new>1</new> </TableAreas> <TableAreas> <table_area_id>54</table_area_id> <typeface>Arial</typeface> <typeface_size>9</typeface_size> <typeface_style>400</typeface_style> <typeface_color>0</typeface_color> <cell_color>2364074</cell_color> <justification>6</justification> <angle>0</angle> <nof_decimals>0</nof_decimals> <new>1</new> </TableAreas> <TableAreas> <table_area_id>51</table_area_id> <typeface>Arial</typeface> <typeface_size>9</typeface_size> <typeface_style>400</typeface_style> <typeface_color>0</typeface_color> <cell_color>2364074</cell_color> <justification>11</justification> <angle>0</angle> <nof_decimals>0</nof_decimals> <new>1</new> </TableAreas> <TableAreas> <table_area_id>12</table_area_id> <typeface>Arial</typeface> <typeface_size>10</typeface_size> <typeface_style>4496</typeface_style> <typeface_color>255</typeface_color> <cell_color>14607331</cell_color> <justification>3</justification> <angle>0</angle> <nof_decimals>2</nof_decimals> <new>1</new> </TableAreas> <TableAreas> <table_area_id>9</table_area_id> <typeface>Arial</typeface> <typeface_size>8</typeface_size> <typeface_style>700</typeface_style> <typeface_color>0</typeface_color> <cell_color>14607331</cell_color> <justification>3</justification> <angle>0</angle> <nof_decimals>0</nof_decimals> <new>1</new> </TableAreas> <TableAreas> <table_area_id>8</table_area_id> <typeface>Arial</typeface> <typeface_size>8</typeface_size> <typeface_style>400</typeface_style> <typeface_color>0</typeface_color> <cell_color>14607331</cell_color> <justification>3</justification> <angle>0</angle> <nof_decimals>0</nof_decimals> <new>1</new> </TableAreas> <TableAreas> <table_area_id>7</table_area_id> <typeface>Arial</typeface> <typeface_size>8</typeface_size> <typeface_style>4496</typeface_style> <typeface_color>0</typeface_color> <cell_color>14607331</cell_color> <justification>3</justification> <angle>0</angle> <nof_decimals>0</nof_decimals> <new>1</new> </TableAreas> <TableAreas> <table_area_id>5</table_area_id> <typeface>Arial</typeface> <typeface_size>9</typeface_size> <typeface_style>400</typeface_style> <typeface_color>0</typeface_color> <cell_color>14607331</cell_color> <justification>2</justification> <angle>0</angle> <nof_decimals>0</nof_decimals> <new>1</new> </TableAreas> <TableAreas> <table_area_id>4</table_area_id> <typeface>Arial</typeface> <typeface_size>9</typeface_size> <typeface_style>400</typeface_style> <typeface_color>0</typeface_color> <cell_color>14607331</cell_color> <justification>3</justification> <angle>0</angle> <nof_decimals>0</nof_decimals> <new>1</new> </TableAreas> <TableAreas> <table_area_id>3</table_area_id> <typeface>Arial</typeface> <typeface_size>9</typeface_size> <typeface_style>400</typeface_style> <typeface_color>0</typeface_color> <cell_color>14607331</cell_color> <justification>2</justification> <angle>0</angle> <nof_decimals>0</nof_decimals> <new>1</new> </TableAreas> </TableStyles> <macro></macro> <type>7</type> <var_type>1075855368</var_type> <var_type2>0</var_type2> <freq_row1_height>18</freq_row1_height> <freq_rown_height>18</freq_rown_height> <freq_col1_width>20</freq_col1_width> <freq_coln_width>9</freq_coln_width> <cross_row1_height>25</cross_row1_height> <cross_row2_height>18</cross_row2_height> <cross_rown_height>18</cross_rown_height> <cross_col1_width>20</cross_col1_width> <cross_coln_width>9</cross_coln_width> <combi_row1_height>18</combi_row1_height> <combi_rown_height>18</combi_rown_height> <combi_col1_width>35</combi_col1_width> <combi_coln_width>9</combi_coln_width> </TableProfiles> The xml file does NOT contain key fields (TableProfiles.layout_id, TableStyles-table_style_id and TableAreas.table_style_id). These unique keys are created again on import. ChartTypes are build from table "ChartProfiles", which links to table "ChartTemplates" by field "chart_template_id". Table ChartTemplates contains Excel Chart template files (*.crtx) The XML file for ChartType "OfficeReports" could look like this: <?xml version="1.0" encoding="UTF-8"?> <ChartProfiles> <layout_name>OfficeReports</layout_name> <macro></macro> <type>7</type> <var_type>2097160</var_type> <var_type2>0</var_type2> <width>550</width> <height>450</height> <ChartTemplates> <template_name>[login to view URL]</template_name> <template>UEsDBBQABgAIAAAAIQDCRXaLIwEAAN0CAAATAAAAW0NvbnRlbnRfVHlwZXNdLnht bKSSyU7DMBCG70i8g+UrSpxyQAgl6YHlCBzKAwzOJLGIF9luad+eySbRqIVDLyMv 8//zeTz5eq87tkMflDUFX6UZZ2ikrZRpCv6xeUnuOQsRTAWdNVjwAwa+Lq+v8s3B YWCkNqHgbYzuQYggW9QQUuvQ0E1tvYZIW98IB/ILGhS3WXYnpDURTUxi78HL/Alr 2HaRPe/peCT51I6zxzGvL1VwpXt9fy5OKjx2YSEB5zolIdLbxM5UC65kYkpJOeSE VrlwQ+BnKvQ3x0y/C0y6N2qmVxWyd/DxFTSRC9nSeozp3yYnKG1dK4mVlVtNPUsr D9/0ObpLB9cZ93zZSH+CYohz0upiiiO7/xkm6CCmxeUAizaEFmiUZhAxDGf5AwAA //8DAFBLAwQUAAYACAAAACEAGaqS89EAAACzAQAACwAAAF9yZWxzLy5yZWxzrJDL igIxEEX3A/5DqL1d3S5EBtNuRHAr+gE1SXV3sPMgiaJ/b5zZTIswm1kWlzr3cNeb mx3FlWMy3kloqhoEO+W1cb2E03E3X4FImZym0TuWcOcEm3b2sT7wSLk8pcGEJArF JQlDzuETMamBLaXKB3Yl6Xy0lMsZewykztQzLup6ifE3A9oJU+y1hLjXCxDHeyjN f7N91xnFW68ull1+U4HGlu4CpNhzlqAGihkta0M/UVN92QD43qT5T5Op66vSt1hV pnu64GTq9gEAAP//AwBQSwMEFAAGAAgAAAAhAJNC0zYZBgAAJR4AAA8AAABjaGFy dC9jaGFydC54bWzkWVFv2zYQfh+w/yAI2GNiS5Zs2agzOHaDFXWaIMlaYG+0RMuc KVKj6MTer98dSSlKYhRp0wTb7DyEOh7veMePJ+rju1+3BfduqaqYFGM/OO76HhWp zJjIx/7vN2dHie9VmoiMcCno2N/Ryv/15Oef3qWjdEWUvi5JSj0wIqpROvZXWpej TqdKV7Qg1bEsqYC+pVQF0fCo8k6myB0YL3gn7Hb7HWPEdwbIdxgoCBP1ePWc8XK5 ZCmdyXRTUKHtLBTlREMGqhUrK/8EgsuIpsGwG3m3hI/9rt9BIScit4KMHM0+WqGS G5HRbCqVgDS29It0NOGaKgGmplJo8ObiLJ6VqYKo9aY8SmVRwuQWjDO9M9OFCYLt 6UpCHN4V/WvDFK3GfhpEdSKg+SQVBUuVrORSH4PFjs1CvRpodtBJOqFbDwg2iEaV 3nFqAwq6IUbbafyaKZwRzhckXWNuWsqN6n0/DnycDByVcnVOyotb9XIILfJg7HMd +J7eQitbQ2uRhygLUQatbA0tkqawEqDhGrUE+q2k0enVkl6tA1m1OpBp24hrSVxL +rWk73srzsQaVgL/+d5S8t+soG5ZBJk9gNkgGy1vmOZ0RjnVNHO5t1oll3qiKEFF TnZyo7FVELEhfN48254bonKq7XAmAJfWxPZcZm5BaZZTK9ztE24djo978TDqhnE/ GXbjMIgGAzfITe04CcNh0G9+yfsjs/rp6K620O/2oyjpJnEURWESJX1rYVX3J1Gv NxzG/ThMkkHQG5r+zuPIQHAf9IKoKRYfTAC0Z0xZY9C2xnPYlCVUGSuG+pWuaWa7 bonaTSWXD7YqwJcqtMayOnKrLVVGnXFXA/QW9SqtrugSd0Q6cpLy8uUgPnlHRrki 2Rnj/MU1cclZOfYFlG3fU1J/YXp1vSIlFPEAKgg4quYVpBAbXimhgHSNuFL5Yspd 0INZF35WviI1eHpGCNGTUUU04MfmOQhiVMasQIc1Y9p51XaDSs921R+AOpr8LlcB unq2L6f9bc4g1CaRsLk9eEVAgvtQUNGzV6WE0wxTbsxqxukVTbXNUb3UBkYVAMhA UMDrWH9YfqI5lP1bt18d+rL5gkMyEXQ/CG4Lme0aU9/9AjbB8Upfm1eGPQ68zFj5 UvwjZExKySijyytMLmBIcmZ2l3nAUwptsA4vkBq791qwvPVoaDp7VGSXRBGw6eGR AF4s9XEAdVxRsKtZreTdnOYw4iPduZKHXqCEQM9nAocvPGAYz1Y2JfoTKR4uO+pe U7VXfkkVvtCe2D7dLBacXrO/n5qaU9jKas4EbZ9XoJQ18EqJKa7tMudEMF2cvdgU TQE0IhjtaujjUupia5VSJzmsUvp+Gs7CwZuU0v2uXqeU7vf1HyilPxLi7szTgriT HBjEk/fw9zYQ3+vqlSC+19eBQbxn31otiDvJYUF8EkzxE8UcH175QLzf1etAfL+v A4N49ATiTnJYEI+6kzg8fROI73f1OhDf7+vAIB4/gbiTHBbEJ9GkP3mbg8p+V68D 8f2+/ucQb75Z/2Wf2u3P6ZyUX1imHecJNJnbhsD0cFI6CsDyXMACbz84Qq0/jONB GCVW+4F8MIxDS7UZCrShQ+GrZmIYygfaLStISAEzit/wUjEgDszFh51CwcQ52aI3 /Jq/V8wMHf2AYSDbS+nIA26nV5A/pbph6foc7i2sLnDUro+Jx32GlzREiIYxQGs1 9gTd6htpB+KVRTVxnCykowkbrg6wqyYwkDn/gyo3Cp9cUq0ZvuATngsrS7VjiUF6 sVxWNVEO+8RqC3m+4ZrNbzlMqxU1JKVJL3Aee/Lcml4rfV/JM9LcLjpLPn1D3hdu tpvirNBwuYB3bFMg+IHI/QWIR7kBXgg4HmC+G37pTdaoBbavrJHpOqX6jlK3Lgv7 gFFBpl2CofXg4sNQaQhebloNaFwy7B2BgZU0m6vNuYEtOwrHo9XPrLoQ3Kk4Uipj VXkKrN66mjh8w+a1mcYCMwNIVBdgGjbKI2jUNxJI5L74Ogs/MLj4ERyokHibgElF i3ZrO6p5A1SduRKoPAVXH2NffcgMcYFIb253T/4BAAD//wMAUEsDBBQABgAIAAAA IQAuFKfH4AAAAMQBAAAaAAAAY2hhcnQvX3JlbHMvY2hhcnQueG1sLnJlbHOskcFK BDEMhu+C71BydzKzBxHZzl5kYU+Czj5AaDPT4kxbmq66b28RUQcWvHhL8pM/X5Lt 7n2Z1Stn8TFo6JoWFAcTrQ+ThuOwv7kDJYWCpTkG1nBmgV1/fbV94plKbRLnk6jq EkSDKyXdI4pxvJA0MXGoyhjzQqWmecJE5oUmxk3b3mL+7QH9ylMdrIZ8sBtQwznV yX97x3H0hh+iOS0cyoURaBzlchTOz45S3UQNlCcuGmymt7qy4FfQNZUb8DJS959I pZ6KH+sHsrf8A/RZxpX4zYSr2/cfAAAA//8DAFBLAwQUAAYACAAAACEA5xCe1K4B AAAxBAAAGwAAAGNoYXJ0L2RyYXdpbmdzL2RyYXdpbmcxLnhtbKSUwW7bMAyGX0Xg fbUdJG1sRAG2Fdhhwxo0ewFWlmNjsmRQWurk6UdZSdP2mFwsmf7Jn/4oe6Wqf17T tsVBezH2xvpKSWhDGKos86rVPfo7N2jLzxpHPQa+pV1WE752dtebbJbn95lqkQKs V6qmirTZdkf91arW0blmTddWfUxOp+INuT7ZjOv8jq3zcpVF1zFFDxwt72fLhxQ9 rNN6SQvukl4slw/zT+nFx8Sz3A+iR0VOAoigx2A6+5f3qZbdb4cNpb36vd+Q6GoJ MxAWey3hD+u/uVEUIGrtFZN4en5BryF7S4n5IoysklDE+PRO7+v6yQGrsaH+BBWv QNpjZ7lrrFzTCDZb5Ms8B3GQMC/LouA9m2PFHQsVe1nM5nkUKFYUZb5Igiz1EZUD +fBDu5t7ErGQBNIqniOscP/LhwjiYnGikkjEmUdgNY8YqxdemWA6wFdzEXtN4Ykv jXGvEpTpBphiDNrREQQF890ZCSdKxodtOBh9q++EfLi1yjQ3W2+Q8JlZGLQ7CTV+ efwJwh8llG+zG04kz/ymw+bP0Q/fb1S++0Ws/wMAAP//AwBQSwMEFAAGAAgAAAAh AGJ3/Kj/AAAANiQAABYAAABjaGFydC9tZWRpYS9pbWFnZTEuYm1w7JhNCsIwEIXj BTyDCxcuXfUA7otuPY6bXEJyEhFceK+Y+MODUMeEFIaRNzDlQdvk5cskpN2Nw9o9 Y0jXTcrtOxduldQr7kvncn7Cex8tB/3rzh75k38PAdZPD73+d8m/n2FPCyX/62kf 58jxcIu1ebyco5TS+Oh/er5q2efnJPb5nhTkT/6sH6yQOfbO3IbW+sVIbKhy/7Hh Gi7pHyw0FPlrUEef5A8WGor8NaijT/IHCw1V8m85v7Wc0aRnf52fpW8w+q//z/Bt DsgfK4/1315PrJ//qR+MxIYq938bruGS/sFCQ5G/BnX0Sf5goaGs8w8hxDwGq/kA AAD//wMAUEsDBBQABgAIAAAAIQBpsSFibAYAAFcbAAAeAAAAY2hhcnQvdGhlbWUv dGhlbWVPdmVycmlkZTEueG1s7FlPjxs1FL8j8R2subdJdpN0s2q22mSTLrTbrjZp UY/OxJlx4xmPbGe3uaH2iISEKIgLEjcOCKjUSlzKp1kogiL1K/Bsz0zGmwm7265A lOaQzNg/v//v+dm5eu1BxNAhEZLyuO3VLlc9RGKfj2kctL07w/6lDQ9JheMxZjwm bW9OpHdt6/33ruJNFZKI3Ia1go4JAjqx3MRtL1Qq2axUpA/TWF7mCYlhbsJFhBW8 iqAyFvgI6EesslatNisRprG3BQR9JgZ6FUExjoDX7cmE+sRMjac1jZBz2WUCHWLW 9oDEmB8NyQPlIYalgom2VzUfr7J1tYI300VMrVhbWNc3n3RdumA8XTM8RTDKmdb6 9daVnZy+ATC1jOv1et1eLadnANj3SZzKUqRZ72/UOhnNAsg+LtPuVhvVuosv0F9f krnV6XQarVQWS9SA7GN9Cb9Rbda31xy8AVl8Ywlf72x3u00Hb0AW31zC96+0mnUX b0Aho/F0Ca0d2u+n1HPIhLPdUvgGwDeqKXyBgmjIo0uzmPBYrYq1CN/nog8ADWRY 0RipeUIm2IeY7OJoJCjWDPAmwYUZO+TLpSHNC0lf0ES1vQ8THHsFyKvn3796/hS9 ev7k+OGz44c/HT96dPzwR0vLWbiL46C48OW3n/359cfoj6ffvHz8RTleFvG//vDJ Lz9/Xg6EDFpo+OLLJ789e/Liq09//+5xCXxb4FERPqQRkegWOUIHPALdjGFcyclI nG/FMMTUWYFDoF1CuqdCB3hrjlkZrkNc490VUDzKgNdn9x1ZB6GYKVrC+UYYOcA9 zlmHi1ID3NC8ChYezuKgnLmYFXEHGB+W8e7i2HFtb5ZA1cyC0rF9NySOmPsMxwoH JCYK6Tk+JaREu3uUOnbdo77gkk8UukdRB9NSkwzpyAmkxaJdGoFf5mU6g6sd2+zd RR3OyrTeIYcuEhICsxLhh4Q5ZryOZwpHZSSHOGJFg9/EKiwTcjAXfhHXkwo8HRDG UW9MpCxbc1uAvgWn38BQr0rdvsfmkYsUik7LaN7EnBeRO3zaDXGUlGEHNA6L2A/k FEIUo32uyuB73M0Q/Q5+wPFKd9+lxHH36YXgDg0ckRYBomdmosSX1wl34ncwZxNM TJWBku5U6ojGf1e2GYW6bTm8K9ttbxs2sbLk2T1RrFfh/oMlegfP4n0CWbG8Rb2r 0O8qtPfWV+hVuXzxdXlRiqFK64bE9tqm845WNt4TythAzRm5KU3vLWEDGvdhUK8z 50mSH8SSEB51JgMDBxcIbNYgwdVHVIWDECfQt9c8TSSQKelAooRLOC+a4VLaGg+9 v7KnzYY+h9jKIbHa42M7vK6Hs+NGTsZIFUjL0TJa1wTOymz9SkoUdHsdZjUt1Jm5 1Yxopig63HKVtYnNuRxMnqsGg7k1obNB0A+BlZtwotes4byDGRlru1sfZW4xNrlI F8kQw+2DuRFoaL2XfVQzTspiZUkRrYf1kT47nmK1AreWJvsG3M7ipCK7+gp2mffe xEtZBC+8BNROpiOLi8nJYnTU9lqNtYaHfJy0vQkcleExSsDrUjeTmAVwpeQrYcP+ 1GTWoVFUOFPMTYIa3H5Yuy8p7NSBREi1g2VoQ8NMpSHAYs3Jyr/WALNelAIl1ehs UqxvQDD8a1KAHV3XksmE+Kro7MKItp19TUspnykiBuH4CI3YTBxgcL8OVdBnTCXc eJiKoF/gek5b20y5xTlNuuKlmMHZccySEKflVqdolskWbgpSLoN5K4gHupXKbpQ7 vyom5S9IlWIY/89U0fsJXEGsj7UHfLjrFRjpTGl7XKiQQxVKQur3BTQOpnZAtMAV L0xDUME1tPkV5FD/2pyzNExaw0lSHdAACQr7kQoFIftQlkz0nUKslu5dliRLCZmI KogrEyv2iBwSNtQ1sKn3dg+FEOqmmqRlwOBOxp/7nmbQKNBNTjHfnEqW7702B/7p zscmMyjl1mHT0GT2z0XM24PFrmrXm+XZ3ltURE8s2qx6lhXuVtBK0/41RTjnVmsr 1pLGa41MOPDissYwmDdECVwkIf0F+x8VPrN/YugNdcgPoLYi+P9CE4Owgai+ZBsP pAukHRxB42QHbTBpUta0aeukrZZt1hfc6eZ8TxhbS3YWf5/T2Hlz5rJzcvEijZ1a 2LG1HVtpavDsyRSFoUl2kDGOcf4M2/oLAAD//wMAUEsBAi0AFAAGAAgAAAAhAMJF dosjAQAA3QIAABMAAAAAAAAAAAAAAAAAAAAAAFtDb250ZW50X1R5cGVzXS54bWxQ SwECLQAUAAYACAAAACEAGaqS89EAAACzAQAACwAAAAAAAAAAAAAAAABUAQAAX3Jl bHMvLnJlbHNQSwECLQAUAAYACAAAACEAk0LTNhkGAAAlHgAADwAAAAAAAAAAAAAA AABOAgAAY2hhcnQvY2hhcnQueG1sUEsBAi0AFAAGAAgAAAAhAC4Up8fgAAAAxAEA ABoAAAAAAAAAAAAAAAAAlAgAAGNoYXJ0L19yZWxzL2NoYXJ0LnhtbC5yZWxzUEsB Ai0AFAAGAAgAAAAhAOcQntSuAQAAMQQAABsAAAAAAAAAAAAAAAAArAkAAGNoYXJ0 L2RyYXdpbmdzL2RyYXdpbmcxLnhtbFBLAQItABQABgAIAAAAIQBid/yo/wAAADYk AAAWAAAAAAAAAAAAAAAAAJMLAABjaGFydC9tZWRpYS9pbWFnZTEuYm1wUEsBAi0A FAAGAAgAAAAhAGmxIWJsBgAAVxsAAB4AAAAAAAAAAAAAAAAAxgwAAGNoYXJ0L3Ro ZW1lL3RoZW1lT3ZlcnJpZGUxLnhtbFBLBQYAAAAABwAHANgBAABuEwAAAAA= </template> </ChartTemplates> </ChartProfiles>