Scoring goals: Create an XML conversion app

To write the conversion app, I took the following steps:
1. Parse the xml files using XDocument from .NET Framework 4.

2. Add an ADO.Net Entity Data Model, built with the Fantasy Soccer database, into the project. Use DevForce code generation to generate DevForce entities/business objects. These steps can be quickly learned by watching this DevForce Silverlight tutorial

3. Use DevForce entitymanager to add the clubs, players and game stats into the database. Note that the solution also contains a method to delete all the records in the database.

Snippets

Here are snippets of 3 of my xml files and how they are structured. Each object’s element matches up directly with its corresponding SQL database table’s fields.

Clubs.xml

Players.xml

GameStats.xml

Download sample

I have attached the zipped conversion app sample code. It contains the following: 

1. The solution.
2. The three xml files.
3. Two FantasySoccer SQL database. One that has not been populated with records and one that has.

Prerequisites

• To run the sample code, you need to have DevForce Silverlight 2010  and any version of Microsoft SQL (Express, 2005 or 2008).