Click here to Skip to main content
15,799,491 members
Home / Discussions / C#
   

C#

 
GeneralRe: equalent c++ operator in c# Pin
lawrenceinba6-Jan-09 21:27
lawrenceinba6-Jan-09 21:27 
Generalbook Pin
Luc Pattyn7-Jan-09 0:24
sitebuilderLuc Pattyn7-Jan-09 0:24 
GeneralRe: book Pin
lawrenceinba7-Jan-09 0:45
lawrenceinba7-Jan-09 0:45 
QuestionC# - Static classes Pin
DineshSharmain6-Jan-09 19:08
DineshSharmain6-Jan-09 19:08 
AnswerRe: C# - Static classes Pin
Guffa6-Jan-09 19:45
Guffa6-Jan-09 19:45 
AnswerRe: C# - Static classes Pin
«_Superman_»6-Jan-09 20:00
professional«_Superman_»6-Jan-09 20:00 
AnswerRe: C# - Static classes Pin
N a v a n e e t h6-Jan-09 20:08
N a v a n e e t h6-Jan-09 20:08 
AnswerRe: C# - Static classes Pin
DineshSharmain6-Jan-09 20:50
DineshSharmain6-Jan-09 20:50 
Thanks for your reply.....
my problem is not related to database....its related to performance & scalability of static classes.

code is as follows -
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();
            }

        }
}


Multiple user will be accessing this class without creating an object so what will happen if 100 users are trying to access the same method of class at the same time.

Dinesh Sharma

GeneralRe: C# - Static classes Pin
N a v a n e e t h6-Jan-09 21:06
N a v a n e e t h6-Jan-09 21:06 
GeneralRe: C# - Static classes [modified] Pin
DineshSharmain6-Jan-09 21:42
DineshSharmain6-Jan-09 21:42 
GeneralRe: C# - Static classes Pin
N a v a n e e t h6-Jan-09 21:53
N a v a n e e t h6-Jan-09 21:53 
QuestionExtract All text values Pin
belzer6-Jan-09 16:51
belzer6-Jan-09 16:51 
AnswerRe: Extract All text values Pin
Not Active6-Jan-09 16:54
mentorNot Active6-Jan-09 16:54 
AnswerRe: Extract All text values Pin
N a v a n e e t h6-Jan-09 17:11
N a v a n e e t h6-Jan-09 17:11 
AnswerRe: Extract All text values Pin
dan!sh 6-Jan-09 17:42
professional dan!sh 6-Jan-09 17:42 
AnswerRe: Extract All text values Pin
0x3c06-Jan-09 21:10
0x3c06-Jan-09 21:10 
QuestionAdding resource at runtime Pin
Xmen Real 6-Jan-09 16:00
professional Xmen Real 6-Jan-09 16:00 
AnswerRe: Adding resource at runtime Pin
N a v a n e e t h6-Jan-09 16:23
N a v a n e e t h6-Jan-09 16:23 
GeneralRe: Adding resource at runtime Pin
Xmen Real 6-Jan-09 16:26
professional Xmen Real 6-Jan-09 16:26 
GeneralRe: Adding resource at runtime Pin
N a v a n e e t h6-Jan-09 16:40
N a v a n e e t h6-Jan-09 16:40 
GeneralRe: Adding resource at runtime Pin
Xmen Real 6-Jan-09 16:43
professional Xmen Real 6-Jan-09 16:43 
AnswerRe: Adding resource at runtime Pin
Jon Rista6-Jan-09 16:45
Jon Rista6-Jan-09 16:45 
QuestionCaching Pin
CrimeanTurtle20086-Jan-09 12:41
CrimeanTurtle20086-Jan-09 12:41 
AnswerRe: Caching Pin
Guffa6-Jan-09 12:57
Guffa6-Jan-09 12:57 
GeneralRe: Caching Pin
CrimeanTurtle20086-Jan-09 13:08
CrimeanTurtle20086-Jan-09 13:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.