Configure and Update capability to .Net code xml to database
Probably 1 or 2 hours of work, nonetheless, we could use some additions to existing work you have done and it should fit your skills as you had developed this part originally.
1) set path value in config file for xml files
2) loop through all xml files in path and load them(using previous code)
make input directory\path to read all xml files in directory
3) when process is rerun make it so database objects are recreated again(not recreating
the database itself as I have other database objects that must stay in place that use the original
1, Start from the CanvasResult table, there is a field: CanvasResultFile, this is used to save the xml file name, use this field to get the primary key of this table which is PK_ID.
2, Use the PK_ID got from step 1 to get the Submissions in Submission table. There is a foreign key between CanvasResult and Submission table
3, Then use the PK_IDs from step 2 to get Forms and Sections, there are foreign keys between Form and Submission table and Section and Form table.
4, Use the PK_IDs from Sections to get all screens,
5, Use the PK_IDs from Screens to get all Responses
After all data are found for a xml file, do the operations need to do (update or insert or delete) YES
so after get all datas delete them from database, then re upload from xml to database.
YES, WITHOUT IMPACTING EXISTING OBJECTS AND DELETING/DROPPING THE ENTIRE DATABASE