I had some spare time yesterday and decided to see what all the "LINQ" fuss was about, so I went and loaded up the MSDN Virtual Lab: Mapping Your Objects to Database Tables with LINQ to SQL. It was a pretty basic run though, but I have to say that so far LINQ looks pretty impressive so far.
As a developer, I have always run into problems when trying to develop business objects and services where I have an object that has dependant objects. Sometimes the object you wish to retrieve e.g. "Customers" might have an "Orders" (1-many) collection associated with it, the paradox comes in when you just want to work with a particular object and not its dependancies, or a particular object and certain dependencies. Linq seems to handle this situation qite elegantly compared to other OR/M solutions out there. Also, the query syntax, although a bit foreign atm, seems pretty powerful and flexible see: 101 LINQ samples.
So far I'm not quite on the band wagon yet, but I would say I'm definately walking towards it.