Sol 3

It took me a bit of time but I finally found a solution for loading a XML file that has accented characters (like áéíóúâä) into a UTF-8 format.  I'm loading data for a client and it ended up having a name in it with an accented e character.  For the first ...

It took me a bit of time but I finally found a solution for loading a XML file that has accented characters (like áéíóúâä) into a UTF-8 format.  I'm loading data for a client and it ended up having a name in it...(read more)

It took me a bit of time but I finally found a solution for loading a XML file that has accented characters (like áéíóúâä) into a UTF-8 format.  I'm loading data for a client and it ended up having a name in it...(read more)

I sometimes forget how to do an XML output formed in a tree when dealing with a single table parent/child relationship.  There is a great explanation on SQL Server Central on *how* to do this.  I am mainly capturing the link and the SQL I just generated to do this.  This query will drill down 12 levels at the most.  Just alter ...

I sometimes forget how to do an XML output formed in a tree when dealing with a single table parent/child relationship.  There is a great explanation on SQL Server Central on *how* to do this .  I am mainly capturing the link and the SQL I just...(read more)

I sometimes forget how to do an XML output formed in a tree when dealing with a single table parent/child relationship.  There is a great explanation on SQL Server Central on *how* to do this .  I am mainly capturing the link and the SQL I just...(read more)

In my new ongoing quest to read source code to be a better developer, Dear Reader, I present to you thirty-second in a infinite number of posts of "The Weekly Source Code." BlogSvc.NET - The AtomPub Server for WCF and .NET Much respect to people who not only release Open Source Software, but also take the time to get a nice, clean ...

.NET 3.5’s LINQ to SQL functionality provides a great way to write data access layer code that automatically handles mapping relational data to object properties.  Although I generally prefer to use stored procedures when performing insert, update or delete operations against a database (see my previous post on this), I still use LINQ to SQL ...

I suggest you have a look at Kirk Allen Evan's blog post: XmlWriterSettings Encoding Being Ignored? http://blogs.msdn.com/kaevans/archive/2008/08/11/xmlwritersettings-encoding-being-ignored.aspx Short explanation is that if you directly or indirectly end up using StringBuilder under the covers, it forces your XML to be written in UTF-16. ...

I was literally in the middle of writing the post when I saw a message from Andrew Davey about how he had implemented the same idea! Of course, his is way better, so I got to code via subtraction. That means subtracting out the crap I had written in a few minutes and dig into his code. There are no unique ideas, right? ;) Either way, it's fun ...