replicating a IDBCommand conection

[george1106]

Hi everyone...

I just was wondoring if there's a way to replicate or Clone a IDBConnection in an application.. look I'm working in a team that is developing app clientes to a kind of DB, that provide us with connections and all functionality necesary, we send instrucctions to this object and it make them happen (because it should be able to work in diferentes DB engines and it should be transparent for the clients we make)... well, the proplem is: we only have 1 IDBConnection shared into 4 clients (Historic register, reports, tendencies, and I can't remeber the other) and when ther try to work together ther interrupt each other... because the connection is occuped.

as I say before, i want to derivate or clone a Connection from this original IDBConnection provided from the central App.

If anyone knows at least a direction, it will be to appreciate.
thanks in advance :D

[george1106]

Hi there!

I found the solution.. I just needed to create a new object with an IDBCommand wich I make an instance with the kind of the original connection (I used a switch)

IDBConnection conexion;
switch(originalConnection.GetType().ToString())
{
case "System.Data.SqlConnection":
conexion = new SqlConnection();
break;
case "NpgsqlConnection":
conexion = new NpgsqlConnection();
break;
}
conexion.ConnectionString = originalConnection.ConnectionString;
conexion.Open();

so that's all. I hope this help someone.

[kenobewan]

Well done :) - thanks for sharing the solution.

[sanketshete3]

You should not rely on copying connection string directly from connection object,
When Persist Security Info = False, is set in the connection string, In that case, Password
will not be set to the connection string, so you might face a login failed error.