How to Cache a DB2 Dynamic Query in ADO.net

Question

Hi,

 

We have a search form in asp.net and based on the selected fields/ Options we are forming a dynamic query. I want to cache this query so that if any other user is trying to search the same thing I can just return the cached output instead of re-executing the query. Our environment is C# asp.net with DB2 as the backend. We are using plane ado.net not MVC.

 

Can anyone please let me know or guide me what to implement.

 

 

Thanks