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: 258
        
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