Which ms technology for searching xml documents?

[Julia]

Hi,
We have an ASP.NET site,and a data base which contains different types of
XML documents
I would like to ask which technology is best to use for searching XML
documents.
My concern is that a 'simple' search on the XML document can retrieve wrong
results
if the search will ignore the fact that the XML have a schema inside
for example assuming I have simple XML

<FirstName>Julia the Last<FirstName>
<LastName>Adriano<LastName>

Running query to look for 'Last' will also find the LastName 'Tag'


Thanks in advance

 

[Marc Jennings]

I would say that XPath is the way to go. That's what it is for, after
all.

 

[Adam Barker]

..NET v2 solves this spectacularly by allowing xpath subqueries in TSQL. In
..NET v1.1 and previous though, you have at least two choices a) use an XML
based database to store your documents, or b) retreive each row and check
contents using XmlDocument.Select() or the other classes in the System.Xml
namespace.

 

[Jon Skeet [C# MVP]]

We have an ASP.NET site,and a data base which contains different types of
XML documents
I would like to ask which technology is best to use for searching XML
documents.
My concern is that a 'simple' search on the XML document can retrieve wrong
results
if the search will ignore the fact that the XML have a schema inside
for example assuming I have simple XML

<FirstName>Julia the Last<FirstName>
<LastName>Adriano<LastName>

Running query to look for 'Last' will also find the LastName 'Tag'

Have you tried XPath? That would be my first port of call.