SQL Server XQuery with LINQ To SQL

LINQ To SQL doesn’t provide a way to include Xquery expressions in queries. The simplest solution is to create SQL user-defined functions that perform the Xquery for you and return scalar results. This works pretty well for small databases, but you lose the benefit of SQL Server’s XML indexes. To get around that, we can modify the SQL command text to expand the function calls into raw Xquery expressions.