You can use VB.NET or C# to write procedural code and create user-defined types and aggregates in SQL Server.

A free tool to reduce coding for developers who like to surface T-SQL database recordsets in a simple collection of customized POCO objects.

In Visual Studio 2003 or 2005, when using the DataSet design surface and creating/editing queries, you use the fairly wonderful Query Builder tool.