Add AutoQuery features to existing service

I have a working service that takes 8-10 inbound params and populates via stored procedure. The stored procedure is fairly complex.

I’m wondering if I can implement a second service that uses the first one (with caching ideally), but adds AutoQuery features (paging, orderby, where clause). Maybe with PocoDataSource?

You can try populating and using a Memory Data Source, here are the docs:

It looks like a ServiceSource would handle everything I need, with the exception of caching (on the original service). Am I understanding that correctly?

Sure try it out. The Memory Data Source does also have caching support where you can specify the cache client to use and duration to cache it for:

It’s working beautifully. This is a game changer!