The XML datatype in SQL Server allows you to store, process and query XML rather easily. There are some caveats, however: You can not compare or order by an XML data type field in SQL Server Entity Framework does not support the XML data type, so your XML field will be converted to a string Continue reading →
The JavaScript function document.getElementById(), long a staple in the front-end web development community, seems pretty straightforward. Unless you’re maintaining an application that uses a legacy Internet Explorer document mode. I found this out the hard way when debugging a legacy application that had been running in IE 5 quirks document mode. After wrapping the legacy Continue reading →
While working with Microsoft’s Open XML SDK 2.5, I came across some difficulties writing dates to an Excel workbook. When writing dates to an existing Excel file used as a template, I noticed that the dates I was passing to my writeToCell() method did not match the dates I found when I opened up the Continue reading →
As I embarked on a new mission to write a home media server application in C#, I needed a way to store an index of media files on my home computer. I could have gone the flat-file route, and stored file information in a simple delimited index file. Instead, I decided to delve into object-relational Continue reading →