C# – Use LINQ To XML to read XML report generated/created by Crystal Report

The requirement to read a XML file to Crystal Report is very common but how can we read a generated XML file by Crystal Report back to object class and why do we have to do that? Let’s consider this case, a company has SAP products and uses Crystal Report to create reports from databases of those products. Now he would like to export data from this SAP system to 3rd party product but this product has no idea about the database structure of SAP. He orders us to write a small program to do that. The question is what should we do now to keep process simple as it should be?

Continue reading C# – Use LINQ To XML to read XML report generated/created by Crystal Report

Windows Phone 7 – Simple database example

Today when I start to play around with developing on Windows Phone 7, I would like to write a first small database application because Windows Phone does not support SQL Server any more. Therefore I must use either LINQ over XML or store the database somewhere on server/Windows Azure and provide services so that the client can access and make query to get and update data. In this small example, I would like to work with LINQ To XML to create a database and update it.

My data object (data entity) is a class of Student with his first name, last name and email built by appending first name and last name as describing below

Continue reading Windows Phone 7 – Simple database example