C#

DineshSharmain wrote:

no. of users are accessing one static method of static class.....that performs any operation like data insertion, update, deletion and fetching from database.....

public static class Foo
{
   public static void FooMethod(string a,string b){
      ....
   }
}

public static class Foo
{
   private static string FooVariable = "";
   public static void FooMethod(){
        // use FooVariable here
   }
}

static public class TempExample
{
static public bool GetCombo(object a, out DataSet dsAccountClass, string strClassType)
        {

            IDBHelper intfDBHelper = DBClient.GetDBHelper();
            dsAccountClass = new DataSet();
            IDataParameter[] arParms = intfDBHelper.CreateDBParamsArray(2);
            arParms[0] = intfDBHelper.CreateNewDBParam("ID", SqlDbType.NVarChar, 6);
            arParms[0].Value = a.strA;
            arParms[1] = intfDBHelper.CreateNewDBParam("ClasificationType", SqlDbType.NVarChar, 1);
            arParms[1].Value = strClassType;
            try
            {
                using (IDbConnection connection = DBClient.GetConnection(a.strSystem))
                {
                    intfDBHelper.FillDataset(connection, CommandType.StoredProcedure, "p_GetSpConditionCalssCombo", dsAccountClass, new string[] { "dt_ProductClassID" }, arParms);
                }

                if (dsAccountClass.Tables[0].Rows.Count == 0)
                    return false;
                return true;
            }
            catch (Exception ex)
            {
                throw DBClientUtils.GetDBErrorMessages(ex, a.strUser);
            }
            finally
            {
                dsAccountClass.Dispose();
            }

        }
}

DineshSharmain wrote:

its related to performance & scalability of static classes.

DineshSharmain wrote:

if 100 users are trying to access the same method of class at the same time

belzer wrote:

How can i extract all the text strings

belzer wrote:

How can i extract all the text strings such as message box messages, text box values etc. so i know what i need to translate.

Xmen wrote:

is there anyway to add resource at runtime ?

CrimeanTurtle2008 wrote:

Cache.Insert("Client", ds);

CrimeanTurtle2008 wrote:

source = new DataView(ds.Tables["FirstName"]);
Cache["Client"] = source;