LINQ to SQL may be on it's way out, but LINQ is no way out at all! And don't worry about LINQ to SQL, the ADO.NET Entity Framework is available and guess what it's awesome.
Another good usage for LINQ is when you need to query an XML file. When working with LINQ to XML you may remember the old days when you used XPath. But don't worry anymore there is support for XPath on LINQ to XML. There are extension methods for LINQ to XML in the System.Xml.Xpath namespace! Read this blog post if you are interested in an example, and find out if there are any performance issues!
Have fun reading!