I have an xml with the name "events.xml". This file need to be send as a parameter to wcf service. The respective data should be loaded into the multiple tables in the SQL server. (Table definitins in the file "events.sql")
The following is the requirement:
1. Address1, Address2, City, State and zip should be added into the "Event" table from the XML if it doesn't exist
2. Label should be mapped to Description, Lat to Latitude, Lng to Longitude in the "Location" table for the Event Address (LocationType value is always "event")
3. scheduletype value is "event schedule" and Description value is "event description" always in the "Schedule" table for the event addresss
4.Subject value is "Schedule subject", Label should be mapped to "Place", <date> values should be mapped to "Startdatetime" in the "ScheduleItem" table.
5.Service should return the count of new records created and count of existing records in each table.
I need help in writing WCF service. Can someone help me on this?