>>My question is how can I globally change each tableadapter to point to a specific connection string?
>>
>>For example, I might want to switch from PROD to the DEV database connection string. I might have 20 tableadapters, changing each one using the property sheet is not desirable.
>>
>>Isn't there a global way to do this?
>
>Well, now I understand what you are trying to do.
>If you want to switch between different databases, the connectionstring itself is the place for that.
>Your tableadapters should always point to the same connectionstring definition of your app.config.
>To switch to a different database, just change the connectionstring in your app.config.

There has to be a better way if you want to access different databases with the same TableAdapters.