Is it possible to cache adapter RetrievalProcedures & FetchTypedView calls or is it just entity fetches via API/QueySpec/Linq?

The stored proc calls are mostly in our legacy data service.

Can't find anything about it in the documentation.

Thanks.

Yes, it's possible if you map the SP resulset into a TypedView.

daelmo wrote:

Yes, it's possible if you map the SP resulset into a TypedView.

Hi David,

How do you cache typedviews? I can't find the syntax for that

You specify caching with the query, you can fetch typedviews with queryspec (see: http://www.llblgen.com/documentation/4.0/LLBLGen%20Pro%20RTF/hh_goto.htm#Using%20the%20generated%20code/QuerySpec/gencode_queryspec_generalusage.htm#typedview) and then simply specify on the queryspec query you use to fetch the typedview that you want to cache the resultset.

Otis wrote:

You specify caching with the query, you can fetch typedviews with queryspec (see: http://www.llblgen.com/documentation/4.0/LLBLGen%20Pro%20RTF/hh_goto.htm#Using%20the%20generated%20code/QuerySpec/gencode_queryspec_generalusage.htm#typedview) and then simply specify on the queryspec query you use to fetch the typedview that you want to cache the resultset.

Thanks for that, I meant using the adapterbase fetchtypedview call (see below) but the QuerySpec way if fine, thanks for your help.

using (DataAccessAdapter adapter = new DataAccessAdapter())
                {
                    adapter.FetchTypedView(owners);
                }
                return owners;