Add AutoQuery features to existing service

ServiceStack Auto Query
1

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?

2

You can try populating and using a Memory Data Source, here are the docs:
https://docs.servicestack.net/autoquery-memory

3

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

4

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:

https://docs.servicestack.net/autoquery-memory#cacheable-data-sources

5

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

2 Likes