public static DBDataSourceConnectionHandler GetSharedConnectionHandler(string DBServerName, string DataBaseName, string UserID, string userPassword, DataSourceProviderType DBProvider)
{
string cnnString = "";
//crates the datasourder connection string
cnnString = GetConnectionString(DBProvider, DBServerName, DataBaseName, UserID, userPassword);
//verifies if there is a connection that matches the connection string
DBDataSourceConnectionHandler handler = null;
lock (_sharedConnectionsTable)
{
if (_sharedConnectionsTable.ContainsKey(cnnString))
{
handler = (DataBaseLibrary.DBDataSourceConnectionHandler)(_sharedConnectionsTable[cnnString]);
}
else
{
handler = new DBDataSourceConnectionHandler(DBServerName, DataBaseName, UserID, userPassword, DBProvider);
_sharedConnectionsTable.Add(cnnString, handler);
}
}
return(handler);
}
public static DBDataSourceConnectionHandler GetDedicatedConnectionHandler(string DBServerName, string DataBaseName, string UserID, string userPassword, DataSourceProviderType DBProvider)
{
DBDataSourceConnectionHandler handler = new DBDataSourceConnectionHandler(DBServerName, DataBaseName, UserID, userPassword, DBProvider);
return(handler);
}
