One or multiple command objects for ASP.NET app to MSSQL (or Acces

Discussion in 'ASP .Net' started by =?Utf-8?B?QWxleCBGaW1pbmU=?=, Sep 11, 2004.

  1. Hi,

    In my web application I am using one single command object to do stuff with
    the db (UPDATE, INSERT etc). for all user sessions. Does it make any
    difference if I:

    a. Keep it this way
    b. create new command for each routine
    c. create new command for each session.

    Any comments are greatly appreciated.

    Thank you
     
    =?Utf-8?B?QWxleCBGaW1pbmU=?=, Sep 11, 2004
    #1
    1. Advertising

  2. =?Utf-8?B?QWxleCBGaW1pbmU=?=

    Cor Ligthert Guest

    Alex,

    When you do not use a class shared, however instance it everytime, it is
    always an independend object in your page at serverside for that session
    which lives as long as the page is processed at the server.

    Cor

    > In my web application I am using one single command object to do stuff

    with
    > the db (UPDATE, INSERT etc). for all user sessions. Does it make any
    > difference if I:
    >
    > a. Keep it this way
    > b. create new command for each routine
    > c. create new command for each session.
    >
    > Any comments are greatly appreciated.
    >
    > Thank you
     
    Cor Ligthert, Sep 11, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?S2VubmV0aCBQ?=

    MySql's equivalence to MsSql's 'TOP' command/function/clause

    =?Utf-8?B?S2VubmV0aCBQ?=, Jan 8, 2005, in forum: ASP .Net
    Replies:
    1
    Views:
    11,788
    John Timney \(ASP.NET MVP\)
    Jan 8, 2005
  2. SAP BASIS Consultant
    Replies:
    1
    Views:
    1,828
    icebattle
    Nov 14, 2003
  3. Jan-Henrik Grobe
    Replies:
    8
    Views:
    1,586
    Jan-Henrik Grobe
    Jan 5, 2005
  4. silversurfer2025
    Replies:
    16
    Views:
    532
    silversurfer2025
    Jul 24, 2006
  5. Himaxda0
    Replies:
    2
    Views:
    86
    Lasse Reichstein Nielsen
    Feb 29, 2004
Loading...

Share This Page