SQL Database with XML fields, select according to XElement using LINQ

Question

I have a table in an SQL database, where the table configuration corresponds to

ID
Name string
data xml

where the datafield might (but not necessarily) contain a descendant element

<config>Some value...</config>

Using LINQ I want to select all the rows that has a data xml element which contains the config element with a value of... say 17.

My approach has been something like:

var query = from x in db
            from y in x.data.descendants("config")
            where y.Value == "17"
            select x;

But this throws an exception about the Value not being valid.

How should I formulate this query?

Regards, Casper

possible duplicate of Can LINQ to SQL query an XML field DB-serverside? — podiluska
– podiluska, Commented Jun 3, 2014 at 10:44

Community · Accepted Answer · 2017-05-23 12:13:27Z

1

I am pretty sure that Linq 2 SQL does not support what you are trying to do. You would probably need to write a custom SQL statement or use a user defined function as discussed in the solution to this SO question: Can LINQ to SQL query an XML field DB-serverside?

edited May 23, 2017 at 12:13

CommunityBot

11 silver badge

answered Feb 3, 2010 at 13:52

Egil Hansen

15.7k8 gold badges41 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Database with XML fields, select according to XElement using LINQ

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related