Linq o SQL to query an XML data column

[Alexandre Brisebois]

I have been trying to use Linq o SQL to query an XML data column I
currently have in my DB,
but it seems that Linq to SQL sees a typed xml column as an XElement,

I don't want to get the full column locally to then use Linq to Xml.

can someone point me in the right direction on this ?

Regards,
Alexandre Brisebois

 

[Marc Gravell]

What exactly do you want to query?

One option, for example, is to use an SP to do the query inside the xml
column, and drag the SP onto the designer surface as a method *uesd* by
LINQ...?

Marc

 

[Alexandre Brisebois]

What exactly do you want to query?

One option, for example, is to use an SP to do the query inside the xml
column, and drag the SP onto the designer surface as a method *uesd* by
LINQ...?

Marc

yea, thats what i resorted to last night,
im just sad that I can't find any intergrated syntax to work with
XQuery but then again,
it would not be right since it would be too technology specific and we
would lose the point of it i guess...

I hope im wrong...

as for what i'm doing, I am storing tasks as xml documents

Regards,
Alexandre