Write a .NET Framework Console Application to match Xml file properties with fields in two databases and check the values are the same.
Budget: £20 – £250 GBP
Process Steps
1. We get XML Files out of “System A”
2. They get deserialized into "Database 1"
3. They then get processed into "Database 2".
These databases similar but not the same i.e., they have different column names. We need the fields mapping from the XML to “Database1” and then from “Database1” to “Database2”. We also need the values checking from the XML to “Database1” and then again from “Database1” to “Database2”.
Deliverables
• The code showing the fields mappings
• The console application needs to list all the Fields with values that do not match.
Platform
• .NET Framework Console Application
• Entity Framework - Database first
• MS SQL
Attached
• Sample XML Files
• Both database Schemas
1. We get XML Files out of “System A”
2. They get deserialized into "Database 1"
3. They then get processed into "Database 2".
These databases similar but not the same i.e., they have different column names. We need the fields mapping from the XML to “Database1” and then from “Database1” to “Database2”. We also need the values checking from the XML to “Database1” and then again from “Database1” to “Database2”.
Deliverables
• The code showing the fields mappings
• The console application needs to list all the Fields with values that do not match.
Platform
• .NET Framework Console Application
• Entity Framework - Database first
• MS SQL
Attached
• Sample XML Files
• Both database Schemas