Hi,

I've defined a view with a recursive CTE query. Unfortunately the average deep of the recursion is about 180. Is there a way to define the option as part of the LINQ query or to configure it in the LLBLGen GUI?

Or is to use a SqlCommand the only way to go?

Kind regards, Danny

Try the following:

1- Derive from DataAccessAdapter. 2- Override OnFetchTypedView. 3- The first parameter (IRetrievalQuery) has the Command object (DBCommand). 4- Try appending the Option to it. 5- Use the derived class when needed, to fetch a TypedView with the Option required.