Hello again, gents! Here's my situation:
We have rather complex search requirements for our apps. One way we minimize performance headaches is buy running smaller chunks of the search in advance, caching the results in a table, and joing these 'temp' results in to later queries. The reason we store these temp results in the DB and not in a client-side cache is that there could easily be millions of rows coming back from the intermediate queries, and we can't clog up the network like that.
So, what I need to do is something like this:
INSERT INTO MyScratchTable(field1, field2...)
SELECT field1, field2...
FROM SearchTable1 JOIN SomeOtherTable
WHERE Field1='foo', Field2 > 10, etc etc
1) Is there a way to do this with the build-in Adapter functionality (something like a super-fancy INSERT FROM with predicates?)
2) If no, is it possible for me to alter the disposition of results, so they are dumped in a table instead of being returned to the client (as in FetchEntityCollection())?
Oh, and I'm on verion 2.0.0.61023 of the runtime libraries, using the Adapter templates.
Thanks much!