XML datatype in SQL Server and LINQ query

Question

I want to retrieve the XML data from SQL Server database and bound it to the DropDownList using LINQ query on C#.

XML field in clients table:

<root>
  <clientname>andrew</clientname> --  dropdownlist text field
  <clientid>1</clientid>          -- dropdownlist value field
  <clientname>jim</clientname>
  <clientid>2</clientid>
  <clientname>john</clientname>
  <clientid>3</clientid>
  <clientname>johnson</clientname>
  <clientid>4<clientid>
</root>

do you have any idea?

Community · Accepted Answer · 2017-05-23 12:19:05Z

1

LINQ (presumably meaning LINQ-to-SQL or EF) doesn't currently have any special treatment of the XML data-type. You'll need to fetch it back as normal, then load it into a DOM and handle from there. Perhaps looking at the question: how to load xml file into dropdownlist in asp.net

edited May 23, 2017 at 12:19

CommunityBot

11 silver badge

answered Nov 23, 2010 at 7:41

Marc Gravell

1.1m273 gold badges2.6k silver badges3k bronze badges

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

Comments

Oleg Kalenchuk · Accepted Answer · 2010-11-23 07:42:45Z

0

It is not clear why you store list of entities as one value. Try to normalize your DB model.

answered Nov 23, 2010 at 7:42

Oleg Kalenchuk

5171 gold badge5 silver badges12 bronze badges

Collectives™ on Stack Overflow

XML datatype in SQL Server and LINQ query

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related