What happens to a bucket after it is used in a fetch? It seems like there is some sort of modification to it.

Where are hitting multiple databases in a loop, each has the same schema, but different database names.

DB1 DB2 DB3

So on my second loop interval, if I use the same bucket for DB2 as I did for DB1, I get an exception dbo.DB1.Table does not exist.

So as a solution I have to create a new bucket for each loop interval. Is there a way to improve this so I can use the same bucket across all DBs?

It checks if the field objects in the predicate objects already have their persistence information set. If so, it skips setting it again. This is done for performance reasons so it doesn't have to lookup the persistence info again.

I think you run into that issue.

I'll file it as an issue so it gets addressed in the current upgrade.

Ahh, It would be cool for the upgrade if we could have a bool for persist info after fetch.