Me too
Not being mad keen on datasets, I've been looking at wholly service oriented architectures, where database content is exposed as xml documents through a webservice model. That's nice until you want to composite on an adhoc(ish) basis. Linq gives you this facility in a very natural and extensible way.
Cleverer than a tin of brains.
Using it intead of SQl on the database, I can't see a lot of use for, and I'm not sanguine about how efficient the autogenerated SQL would be, especially if the DBMS wasn't SQL Server.