Formatting old Query to LINQ statement

Question

The following query is something i inheritted from an old app that adds 2 attributes to an excel stored in the database.

SELECT row_number() over(order by id) as num,[id] as mailsort, 0 as pages,[xmlRecord].query('/sst-statement/*') FROM  dbo.RPA200_preproc as [sst-statement] where rpatype = 201 order by id for xml auto

returns an xml starting with

<sst-statement num="1" mailsort="32" pages="0">

now, the SQL would need to be translated to a LINQ statement. Is that possible similar to this query or would it be better to retreive the xml from database and then change the xml?