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

I've looked at Linq to SQL/XML today briefly. Should I create either an entity data model or Linq to SQL class from my tables and use this as my "base".