Is it possible to query a XML file with SQL?
Posted
by Monty
on Stack Overflow
See other posts from Stack Overflow
or by Monty
Published on 2010-04-26T08:56:12Z
Indexed on
2010/04/26
9:03 UTC
Read the original article
Hit count: 224
Currently I'm working on a case where we don't want to change to much on a c#/wpf program, but like to add a feature. Currently we allow certain users to add sql queries to a database to retrieve customer data, hereby a custom connection string/ provider name must be specified. With this information it's possible to create the connection and obtain the data with c#.
However we like to add the possibility to allow that user group to query XML files too, with a certain connection string/ provider name. I just had a look for possibities in .net to do that, but can't seem to find a decent way... Is something like this possible? (OleDb/ODBC way maybe?)
Thanks in advance.
© Stack Overflow or respective owner