Generating an Time table in SQL

In reporting queries it happens often that you need a ruler of some sort for instance a table containing all days between a start and end date. You can generate such tables by using a looping construct but this isn't the strong point of SQL.

Embedded Sql, LINQ like behaviour

When ever you create an application which uses a database. There certainly are variatons but you have basically two option when it comes to how you have de SQL-Statements. You can choose to type the SQL-statements in the source code or you can create stored procedures. Both of these have their own advantages and disadavatanges.
In-code statements ensure that when te application is deployed, no stored procedures have to be updated. Stored procedures on the other hand offer better speed and reusablility.

To allow stored procedures to be created, maximize easy of deployment I created the this. The .sql files can be edited in either Visual Studio or the SQL Management studio with full support of the syntax checkers and code-Highlighting. This class does have one other main feature it makes each declared procedure available as a strong type .NET class to access the parameters.

Captcha

For this site I wanted to add some mechanism to avoid getting the article comments spammed with links and other junk. To this end I added validation using captcha. I found the code to generate the image on the internet and extended it a little. I extended a TextBox control and created a Http Handler to facilitate easy use. The code for these is downloadable here.

This site

As you probably will guess and easily can see this site is written in .NET to be more specific in C# .NET 2.0. It also uses some content management. This basic content management system was written in a single weekend. Granted it isn't entirely fool-proof nor does it offer the options of the system available like DotNetNuke, but using some of the framework .NET features this system offers the same extensibility. The content management is an extension of the framework it self.

Generic strong Type String to Any Converter

This is one of the oldes pieces of code i wrote in .NET and still use. This class is written for conversion of xml node values to a .NET type but can also be used to with plain strings. Every time I needed a node value I had to check if the node existed, is it an element or an attribute before I could even start converting the value. This class handles all this and using generics and the IConvertible interface returns all strongly types and correctly converted.