SQL Commands using XML files

[rustyfancy]

Hey,

 

Just wondering if anyone had any knowledge about data access using SQL commands with XML, under a C#.NET atmosphere. I'm using XML files to store and retrieve data...and I need to specific queries on this data. I'm new to this, so if anyone has any code samples of SQL commands...send them my way (rustyfancy@hotmail.com)

 

---Matt

[wyrd]

You might be looking for the FOR XML clause. You can find all the documention on it either in the Books Online (BOL) or MSDN.

 

SELECT Customers.CustomerID, ContactName, CompanyName,

Orders.CustomerID, OrderDate

FROM Customers, Orders

WHERE Customers.CustomerID = Orders.CustomerID

AND (Customers.CustomerID = N'ALFKI'

OR Customers.CustomerID = N'XYZAA')

ORDER BY Customers.CustomerID

FOR XML AUTO

[Volte]

You might want to look into using XPath, the XML querying language. Check out the [msdn]System.Xml.XPath[/msdn] namespace.