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;

CrimeanTurtle2008 wrote:

Would I need to insert the dataset into the cache after declaring what the
source is?

CrimeanTurtle2008 wrote:

How would I remedy this?

CrimeanTurtle2008 wrote:

Would I need to insert the dataset into the cache after declaring what the
source is?

public partial class Caching_ApplicationCaching : Page
{
	const string QUERY = "SELECT firstname, lastname FROM customers";
	const string CACHE_KEY = "Client";

	protected void Page_Load(object sender, EventArgs e)
	{
		DataTable source = GetCustomersTable();

		DropDownList1.DataSource = source;
		DropDownList1.DataTextField = "FirstName";
		DropDownList1.DataBind();
	}

	private DataTable GetCustomersTable()
	{
		DataTable source = (DataTable)Cache[CACHE_KEY];

		if (source == null)
		{
			source = PopulateCustomersCache();
		}

		return source;
	}

	private DataTable PopulateCustomersCache()
	{
		using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
		{
			using (SqlCommand command = new SqlCommand(QUERY, conn))
                        {
			    conn.Open();
			    command.CommandType = CommandType.Text;

			    SqlDataAdapter adapter = new SqlDataAdapter(command);

			    DataSet ds = new DataSet();
			    adapter.Fill(ds, "Customers");

			    DataTable dt = ds.Tables["Customers"];
			    Cache.Insert(CACHE_KEY, dt);

			    return dt;
                        }
		}
	}
}