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 →
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 →