Having watched the video I'm bowled-over by the concept. Oddly though, it reminds me of accessing files in COBOL. No doubt I'll be hung drawn and quartered for even thinking that.
Still, Linq and DLinq make far more sense to me than SQL ever did. As Anders Hejlsberg says in the video, the statements are in a more natural order. I can even see how I'd use it in the app I writing at the moment.
Roll on .Net 3!