I have a question about LINQ to dataset.
I a class in my application which is very database intensive. As the requirements for the application are evolving and have grown to the point where we need to tweak the speed of the algorithm.
I am trying to find a solution which would fit into the flow of the algorithm so that it could be easily integrated following the same logic. I believe Linq to dataset will meet my needs.
Here is my Question:
I have a dataset named dsNorthwind in my application, lets say i am totally disconnected from my datasource, i can't do Linq to sql because of the requirements. Ok, i want to take dsNorthwind and run Linq query on it.
Could someone give me a way to translate the following sql query to Linq to dataset on dsNorthwind.
Select * From Customers where customercity = 'London';
Here is the one other issue, i need to declare another dataset name dsNorthwindFiltered, this dataset will store the results from the Linq query. So i guess i have to somehow cast it back to a dataset.
If someone could help me or lead me in the right direction i would really appreciate it.