Databases aren’t something I’ve written about on the blog – I’ve focused mostly on Windows Home Server specific development techniques, with some WiX goodness thrown in.
Just about every large application in existence is backed by some sort of database, and Microsoft goodies like SQL Compact Edition mean light-weight apps are also likely to have a relational data store of some kind. There are plenty of Windows Home Server-based uses for a database.
Mindscape are a local crew (local to us here in New Zealand, at least) who build tools for developers. They’ve just released version 3.0 of their LightSpeed O/RM tool, and they’ve hammered on a lot of features and polish.
One of the most awesome bullet points is the new visual migrations framework that lets you push schema changes to your database from within Visual Studio, and put those changes them under version control. No more SQL database backups getting checked into Subversion.
I’ve only begun to play around with basic data input and output in LightSpeed, but what I’ve seen so far has been very impressive. We’ve been hunting about for something to replace LINQ to SQL in our internal development framework, and I’m starting to think we have a winner.
The express version is free, and supports up to 8 entities, so you don’t have any excuse. Go play with it.