19. August 2007
If you are like me you probably have a hard time finding something to create when trying out new stuff. This time I sat down and tried to figure out something to use LINQ and Silverlight for and maybe WCF, WPF and Ajax as well. At the time I was watching TV and the EPG (Electronic Programming Guide) didn’t work, so I started to look for a web site with a program guide supporting reminders and other nice features to let you know what’s on TV. I didn’t find anything good.
I then started to look for an xml/text format for TV programs. I did some searching and came across xmltv. Nice! I now had an xml source looking something like this:
<tv>
<channel id=“channel1“>
<display-name lang=“nb“>Channel 1</display-name>
</channel>
<channel id=“channel2“>
<display-name lang=“en“>Channel 2</display-name>
</channel>
…
<programme start=“20070801033000 +0200“ stop=“20070801053000 +0200“ channel=“channel1“>
<title lang=“nb“>Program 1</title>
<desc lang=“nb“>Program description.</desc>
<credits>
<director>…</director>
<actor>…</actor>
<actor>…</actor>
</credits>
<date>2004</date>
<category lang=“en“>movie</category>
<category lang=“en“>drama</category>
</programme>
…
</tv>
So now I had an xml document containing all the data I needed
and this was a perfect time to try out XLINQ. I decided to stick with the LINQ
query syntax and not mix in Lambda expressions to keep things simple and
readable. I came up with this expression to get all TV channels:
public List<TvChannel> GetTvChannelsWithoutGuide(){ IEnumerable<TvChannel> channels;
try {
XElement tvGuide = XElement.Load(_xmlFileLoc);
channels = from c in tvGuide.Descendants("channel") orderby (string)c.Element("display-name") ascending select new TvChannel { Id = (string)c.Attribute("id"), Name = (string)c.Element("display-name"), Lang = (string)c.Element("display-name") .Attribute("lang"), TvGuideLoaded = false }; }
catch (FileNotFoundException fileNotFoundEx)
{
throw new FileNotFoundException( string.Format("Xml file for tv guide not found at {0}", _xmlFileLoc), fileNotFoundEx);
}
return channels.ToList<TvChannel>();
}
The XElement gives me the complete xml document that I can
use XLINQ expressions on. In my query I’m looking only for TV channels, so I
specify that in the query by
from c in tvGuide.Descendants(“channel”)
This gives my a variable c that I use in my orderby clause and select statement. The orderby clause
orderby (string)c.Element(“display-name”) ascending
uses the c variable to access the “display-name” element to set order by. But it’s the select statement which is the cool thing here! First here a listing of the TvChannel class:
[Serializable]public class TvChannel
{ public string Id { get; set; }
public string Name { get; set; }
public string Lang { get; set; }
[XmlIgnore] public IEnumerable<TvProgramme> TvGuideNonSerializable {
get { return TvGuide; }
set { TvGuide = value.ToList(); }
}
public List<TvProgramme> TvGuide {
get;
set;
}
public bool TvGuideLoaded { get; set; }
}
Ignore the TvGuideNonSerializable property for now. By using select new TvChannel I can create an object of my TvChannel class an assign data from the xml document to my properties. I just love this syntax! It’s really nice and easally understandable. Another cool feature (running VS 2008 Beta 2) is that you get ItelliSense in LINQ for your classes, like this:
I also created other methods for retrieving all programs for one channel, all channels etc. At the time of writing I’m working on a Silverlight implementation for the TvGuide which I hopefully can show you soon. And later I’ll make all source code available.
Most of us
I’ve been
Just
I just installed a new VM with Visual Studio 2008 and ran the Windows update to have a fully updated OS. There were 82 updates to download! About time to ship service pack 3? 