I have a MS SQL database that has multiple tables. One table has a column that has xml that provides the structure of a custom table with a relationship to the aforementioned table and another table that has a column with xml that has the data for that table. I need to have a way to query the database including the table(s) that are defined in xml. I know there is a way to use LINQ to query a dataset. The problem is the queries are too complicated to convert to LINQ.
How do you expect anyone to chime in without providing (sample) XML from the column with the structure of this custom table? Post anything that might help other people help you!
I have a MS SQL database that has multiple tables. One table has a column that has xml that provides the structure of a custom table with a relationship to the aforementioned table and another table that has a column with xml that has the data for that table. I need to have a way to query the database including the table(s) that are defined in xml. I know there is a way to use LINQ to query a dataset. The problem is the queries are too complicated to convert to LINQ.
no sorry, I can't "Feel the Source"
to hunt a species to extinction is not logical !
since 2010 the number of Tigers are rising again in 2016 - 3900 were counted. with Baby Callas it's 3901, my wife and I had 2-3 months the privilege of raising a Baby Tiger.
Please see the attached document and xml files for an example of what I am trying to accomplish.
What I have been trying to do is
a. extract the names of the tables from the query
b. Construct any custom form tables that are among the tables named in a.
c. add all the tables named in a. to a dataset
d. run the query on the dataset
Last edited by dd_smith; Nov 9th, 2022 at 05:33 PM.
Please see the attached document and xml files for an example of what I am trying to accomplish.
What I have been trying to do is
a. extract the names of the tables from the query
b. Construct any custom form tables that are among the tables named in a.
c. add all the tables named in a. to a dataset
d. run the query on the dataset
Please, any help would be appreciated. This is somewhat urgent. I am working with existing code and I don't have the luxury of time to redesign and code the application.
This looks like work, like an actual daytime job so no one is willing here to touch it or do it for free. Why would they?
I peeked briefly at the files and frankly I wouldn't touch such BS even if they were willing to pay me generously.
cheers,
</wqw>
I have the code that converts the two XML columns to a table. What I am asking is how to include the derived table in a query. I have already looked into querying a dataset, but it isn't supported. The only way that I can find is using LINQ to Dataset. However, the application I am working on is written to specifically use SQL. It would take a lot of rewrite of code to convert all the possible queries to LINQ. That is why I was hoping for a workaround.
Last edited by Zvoni; Tomorrow at 31:69 PM.
----------------------------------------------------------------------------------------
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------------------
People call me crazy because i'm jumping out of perfectly fine airplanes.
---------------------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad