ASP.NET

ASP.NET RSS

Static methods in DataLayer

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Jan 2009

Posts: 2

Reputation: koppv0 is an unknown quantity at this point

Solved Threads: 0

koppv0

Offline

Newbie Poster

Static methods in DataLayer

Jan 7th, 2009

Hi,
i am using the following code in the datalayer. The input paramters are the stored procedure and the associated parameters provided as a HastTable. I am using Enterprise Library, Data Access Block.
--------------

 Help with Code Tags 
 asp.net Syntax (Toggle Plain Text) 
namespace EPD.Data
{
    public class DBManager
    {  
 
        static Microsoft.Practices.EnterpriseLibrary.Data.Database dataBase;     
        static DbCommand oDbCommand;     
 
        public static CommandResult ExecForScalar(string procName, Hashtable paramValCol)
        {           
 
            CommandResult cmdResult;
            try
            {
                dataBase = Microsoft.Practices.EnterpriseLibrary.Data.DatabaseFactory.CreateDatabase();
                CommonManager.PrepareCommand(ref dataBase, ref oDbCommand, procName, paramValCol);
                cmdResult = CommonManager.BuildResult(dataBase.ExecuteScalar(oDbCommand), 
                    (int)Constant.ResultType.Scalar);
 
            }
            catch (SqlException ex)
            {
                cmdResult = CommonManager.BuildResult(ex);
            }
            catch (Exception ex)
            {
                cmdResult = CommonManager.BuildResult(ex, (int)ExceptionHandler.ErrorCode.NonSQL);
            }
            return cmdResult;
        }
}  }
namespace EPD.Data
{
    public class DBManager
    {  
            
        static Microsoft.Practices.EnterpriseLibrary.Data.Database dataBase;     
        static DbCommand oDbCommand;     
              
        public static CommandResult ExecForScalar(string procName, Hashtable paramValCol)
        {           
             
            CommandResult cmdResult;
            try
            {
                dataBase = Microsoft.Practices.EnterpriseLibrary.Data.DatabaseFactory.CreateDatabase();
                CommonManager.PrepareCommand(ref dataBase, ref oDbCommand, procName, paramValCol);
                cmdResult = CommonManager.BuildResult(dataBase.ExecuteScalar(oDbCommand), 
                    (int)Constant.ResultType.Scalar);

            }
            catch (SqlException ex)
            {
                cmdResult = CommonManager.BuildResult(ex);
            }
            catch (Exception ex)
            {
                cmdResult = CommonManager.BuildResult(ex, (int)ExceptionHandler.ErrorCode.NonSQL);
            }
            return cmdResult;
        }
}  }

--------------------------------------------------

I invoke the method from the business layer as follows:
CommandResult result = EPD.Data.DBManager.ExecForScalar("proc", hash table containing the parameters);
Question:
since the basic method is static and need to know if it affects the concurrent users.

Last edited by peter_budo; Jan 11th, 2009 at 2:47 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.