using xquery linq sql?

let's contend i have list buttress xml form data. within sql, i govern following statement:

select   tip 10  *,
         content.value('(/root/item/value)[1]', 'float') value
from     xmltabletest
where    content.value('(/root/item/messagetype)[1]', 'int') = 1

the outcome set contains wholly annals relating criteria, extracts value xml buttress called 'value'. good simple.

can same thing achieved linq sql?

i'd sql complicated lifting wholly relapse information relating criteria rather carrying select, transfer, following slight potentially large brick data. distant i tell isn't illusory during moment, nonetheless i guess i should ask.

(the sourroundings .net 3.5, vs2008, sql server 2005 helps)