In previous blog posts I have discussed how
to use XML files
to store data in your applications. I showed you how
to read those XML files from your project and get XML from a WCF service. One of the problems with reading XML files is when elements or attributes are missing. If you try
to read that missing data, then a null value is returned. This can cause a problem if you are trying
to load that data into an object and a null is read. This blog post will show you how
to create extension methods
to detect null values and return valid values
to load into your object.
The XML Data
An XML data file called Product.xml is located in the \Xml folder of the Silverlight sample project for this blog post. This XML file contains several rows of product data that will be used in each of the samples for this post. Each row has 4 attributes; namely ProductId, ProductName, IntroductionDate and Price.
<Products> <Product ProductId="1" ProductName="Haystack Code Generator for .NET" IntroductionDate="07/01/2010" Price="799" /> <Product ProductId="2" ProductName="ASP.Net Jumpstart Samples" IntroductionDate="05/24/2005" Price="0" /> ... ...</Products>
The Product Class
Just as you create an Entity class
to map each column in a table
to a property in a class, you should do the same for an XML file too. In this case you will create a Product class with properties for each of the attributes in each element of product data. The following code listing shows the Product class.
public class Product : CommonBase{ public const string XmlFile = @"Xml/Product.xml";
private string _ProductName; private int _ProductId; private DateTime _IntroductionDate; private decimal _Price;
public string ProductName { get { return _ProductName; } set { if (_ProductName != value) { _ProductName = value; RaisePropertyChanged("ProductName"); } } }
public int ProductId { get { return _ProductId; } set { if (_ProductId != value) { _ProductId = value; RaisePropertyChanged("ProductId"); } } }
public DateTime IntroductionDate { get { return _IntroductionDate; } set { if (_IntroductionDate != value) { _IntroductionDate = value; RaisePropertyChanged("IntroductionDate"); } } }
public decimal Price { get { return _Price; } set { if (_Price != value) { _Price = value; RaisePropertyChanged("Price"); } } }}
NOTE: The CommonBase class that the Product class inherits from simply implements the INotifyPropertyChanged event in order
to inform your XAML UI of any property changes. You can see this class in the sample you download for this blog post.
Reading Data
When using
LINQ to XML you call the Load method of the XElement class
to load the XML file. Once the XML file has been loaded, you write a
LINQ query
to iterate over the “Product” Descendants in the XML file. The “select” portion of the
LINQ query creates a new Product object for each row in the XML file. You retrieve each attribute by passing each attribute name
to the Attribute() method and retrieving the data from the “Value” property. The Value property will return a null if there is no data, or will return the string value of the attribute. The Convert class is used
to convert the value retrieved into the appropriate data type required by the Product class.
private void LoadProducts(){ XElement xElem = null;
try { xElem = XElement.Load(Product.XmlFile);
// The following will NOT work if you have missing attributes var products = from elem in xElem.Descendants("Product") orderby elem.Attribute("ProductName").Value select new Product { ProductId = Convert.ToInt32( elem.Attribute("ProductId").Value), ProductName = Convert.ToString( elem.Attribute("ProductName").Value), IntroductionDate = Convert.ToDateTime( elem.Attribute("IntroductionDate").Value), Price = Convert.ToDecimal(elem.Attribute("Price").Value) };
lstData.DataContext = products; } catch (Exception ex) { MessageBox.Show(ex.Message); }}
This is where the problem comes in. If you have any missing attributes in any of the rows in the XML file, or if the data in the ProductId or IntroductionDate is not of the appropriate type, then this code will fail! The reason? There is no built-in check
to ensure that the correct type of data is contained in the XML file. This is where extension methods can come in real handy.
Using Extension Methods
Instead of using the Convert class
to perform type conversions as you just saw, create a set of extension methods attached
to the XAttribute class. These extension methods will perform null-checking and ensure that a valid value is passed back instead of an exception being thrown if there is invalid data in your XML file.
private void LoadProducts(){ var xElem = XElement.Load(Product.XmlFile);
var products = from elem in xElem.Descendants("Product") orderby elem.Attribute("ProductName").Value select new Product { ProductId = elem.Attribute("ProductId").GetAsInteger(), ProductName = elem.Attribute("ProductName").GetAsString(), IntroductionDate = elem.Attribute("IntroductionDate").GetAsDateTime(), Price = elem.Attribute("Price").GetAsDecimal() };
lstData.DataContext = products;}
Writing Extension Methods
To create an extension method you will create a class with any name you like. In the code listing below is a class named XmlExtensionMethods. This listing just shows a couple of the available methods such as GetAsString and GetAsInteger. These methods are just like any other method you would write except when you pass in the parameter you prefix the type with the keyword “this”. This lets the compiler know that it should add this method
to the class specified in the parameter.
public static class XmlExtensionMethods{ public static string GetAsString(this XAttribute attr) { string ret = string.Empty;
if (attr != null && !string.IsNullOrEmpty(attr.Value)) { ret = attr.Value; }
return ret; }
public static int GetAsInteger(this XAttribute attr) { int ret = 0; int value = 0;
if (attr != null && !string.IsNullOrEmpty(attr.Value)) { if(int.TryParse(attr.Value, out value)) ret = value; }
return ret; }
... ...}
Each of the methods in the XmlExtensionMethods class should inspect the XAttribute
to ensure it is not null and that the value in the attribute is not null. If the value is null, then a default value will be returned such as an empty string or a 0 for a numeric value.
Summary
Extension methods are a great way
to simplify your code and provide protection
to ensure problems do not occur when reading data. You will probably want
to create more extension methods
to handle XElement
objects as well for when you use element-based XML. Feel free
to extend these extension methods
to accept a parameter which would be the default value if a null value is detected, or any other parameters you wish.
NOTE: You can download the complete sample code at my website. http://www.pdsa.com/downloads. Choose “Tips & Tricks”, then "Read XML Files using
LINQ to XML and Extension Methods" from the drop-down.
Good Luck with your Coding,Paul D. Sheriff
