C#

leena206 wrote:

I posted it here cz anyways coding is in C# only ..
r8??
n thanks fr help ..

Kevin Marois wrote:

but it doesn't compile in 4.5:

Bastard Programmer from Hell

anishkannan wrote:

i) create new connection for every request of user.

anishkannan wrote:

ii) single connection pool via singleton object of the class

anishkannan wrote:

iii) session based connection pool ( each user has separate connection pool)

Bastard Programmer from Hell

<pre lang="c#">
   public DataSet ExecuteProcedure(string strProcedure, Hashtable hashTableParameters, string tableName, ref DataSet datasetToFill)
        {
            try
            {
                Open();//  objConnection = new OracleConnection(strConnection);
                // Procedure Execution 
                // data fill to dataset 
            }
            catch (OracleException ex)
            {
                throw ex;
            }
            catch (Exception e)
            {
                
            }
            finally
            {
                Close(); // objConnection.Close();
            }

            return datasetToFill;
        }

using (objConnection = new OracleConnection(strConnection))
{
  // do your stuff here
  using (objCommand = objConnection.CreateCommand())
  {
  }
}
// no need to close or dispose.

Bastard Programmer from Hell

anishkannan wrote:

catch (OracleException ex)
{
throw ex;
}

anishkannan wrote:

catch (Exception e)
{

}