Common Table Expressions, Reversed

There was an interesting question left on my last post entitled Hierarchies WITH Common Table Expressions. Basically in this post I showed a couple of ways that you can use SQL Server 2005’s new “Common Table Expressions” (the “WITH” SQL statement) to retrieve a subset of a hierarchy of data. The question concerned inverting how…

6

Loving LINQ

I have to say, I love how easy it is to do SQL-like expressions over collections of objects with LINQ… If we have two simple classes that define our data; class Person {     public int Id { get; set; }     public string Name { get; set; }     public int AddressId { get;…

2

WPF Composite Client

Some top news has been circulating over the past few days or so – Glenn Block has a good summary. Basically there are plans for p&p to produce guidance on building Composite Applications with WPF – new guidance built from the ground up, learning lessons from all the projects and deliverables in this space over…

1

Packaging Software Factories

Jezz Santos has posted an announcement on a series of white papers becoming available on the MSDN Architecture Center covering the packaging and building of Software Factories – the first installment has been published already and is entitled “Packaging With Visual Studio 2005“. This should be a really good series, and includes real practical help…

1

Two approaches to a LINQ Solution Structure

Background I’m in the process of writing a small windows application with a very straightforward architecture, for which the only twist is the need to be able to plug in different data providers according to how it is used. This means it must be able to handle SQL 2005, other database servers, XML files, flat…

3

Hierarchies WITH Common Table Expressions

Storing hierarchical data in a database is a very common task, and SQL Server 2005 brings us Common Table Expressions (CTEs) – a very useful tool for retrieving such data both elegantly and efficiently. I haven’t actually used these before, and they came to mind during a session with a customer, so I did a…

13

"Hello, World" and an introduction

Welcome to my new blog! I have actually been blogging for quite a while already, but as I’ve recently got my “blue badge” and joined the ranks of Microsoft it seemed an appropriate time to relocate my blog. I’ve joined as an Application Development Consultant – check out our Team Site to see what we…

1