1

In my project I am using an XML-file for datastorage. I am accessing that file with linq-to-xml queries. Actually I have created that XML-file from my SQL-server database but as that tables in SQL contained more that 50 columns, the resulting XML-file is also having more than 50 elements...

Now while applying queries I initially load that XML-file in XDocument object and after that applying queries on that.

My main problem is that as it contain more than 50 element it is very difficult to write queries without intellisence support. Why it is not supporting intellisence? What have I done wrong? What can I do to get intellisence support?

Kolky
  • 2,917
  • 1
  • 21
  • 42
prasad kasar
  • 11
  • 3
  • Not sure if it is a perfect dupe or not, but check this question - http://stackoverflow.com/questions/21912/intellisense-for-xelement-objects-with-xml-schema - the answer is you can't get Linq to Xml intellisense in C#. – Merlyn Morgan-Graham Dec 19 '11 at 11:06

2 Answers2

4

LINQ to XML is based on strings and it isn't confined to documents that follow some schema. That's the reason you don't get IntelliSense, VS has no information about the schema.

If this is really important for you, maybe using something like xsd.exe to generate classes that represent the schema would be better for you.

svick
  • 236,525
  • 50
  • 385
  • 514
1

It's not possible to get intellisense for Linq to Xml. This is because you load a file at runtime and you expect it to have compile time intellisense. What if you would load a different file at runtime, would you then get a compile time error?

What you could do is generate classes from your Xml file and then deserialize your XML file into these classes. The you can use Linq To Objects to access the data.

Here is some documentation for creating your classes.

Wouter de Kort
  • 39,090
  • 12
  • 84
  • 103