private ThreadedSql GetClient()
{
ThreadedSql existingClient = null;
//return available client
foreach (ThreadedSql client in _threadedSqlCollection)
{
if (!client.IsActive)
{
existingClient = client;
existingClient.Clear();
}
}
return(existingClient);
}
private IList <ThreadedSql> ConstructPool()
{
IList <ThreadedSql> objectPool = new List <ThreadedSql>();
for (int counter = 0; counter < _startingCount; counter++)
{
//construct default parameters
ThreadedSql.ThreadedSqlParameters param = GetNullParamaters();
//create default client
ThreadedSql client = new ThreadedSql(param);
//connect client to Db
objectPool.Add(client);
}
return(objectPool);
}
