I'm trying to prevent the DynamicQueryEngine from running the query that is generated and instead capture the SQL/parameters. When overriding the OnFetchTypedList method of the dataaccessadapter, what do you call to prevent the execution of the query against the database?

Even if I don't call the base method the query is still executed.

Thanks

I don't think that's possible. Anyway I'll escalate your question.

That's not easy, as the OnFetchTypedList is called prior to the execution, so whatever you do, it simply proceeds.

You have to override ExecuteMultiRowDataTableRetrievalQuery as well. You should set a flag in the DataAccessAdapter derived class (a boolean private field) when OnFetchTypedList is called, and in the override of ExecuteMultiRowDataTableRetrievalQuery, you should check the flag. If it's true, simply return, otherwise call the base' method.

Ok, the ExecuteMultiRowDataTableRetrievalQuery override work wells to stop the query from running. Is it still necessary to call the OnFetchTypedList override as well? I notice it never gets called if I return false from the ExecuteMultiRowDataTableRetrievalQuery override.

Is there a better way to just get the select statement and sql parameters without calling the adapter.fetchtypedlist?

Sorry, it does call the onfetchtypedlist override first...i was mistaken.