markrendle/Simple.Data — Issue #126: UseSharedConnection is completely wrong
Author: markrendle
Created: 2011-11-26 11:59:01+00:00
State: open

The UseSharedConnection method sets the connection at the adapter level, and the adapter is shared by all database objects because it's cached. This is because you are an idiot.

Since you already released this API, the best solution would be to have an adapter per database instance. I suspect there are other good reasons for this approach to. So optimise the AdoAdapter creation code to create new adapters but with shared stuff like schema info.

Seriously, I despair of you sometimes.