locked
Data Access Layer Using Table Adapter Concurrency Issue RRS feed

  • Question

  • User662258659 posted

    Hi,

    I'm using tableadapter in my DAL layer, eveything was working fine if there's only one user executing query. However, when I tested it in a multi-user environment it seems that it only execute one transaction (one insert query) , although, we had try to excute the query concurrently 10 user at once. Please let me know how to solve this, cause i'll need them urgently. Thanks  

    Wednesday, May 18, 2011 6:23 AM

Answers

  • User1867929564 posted

    Thorughly check the code and its property,if there is any lock define.
    refer this,

    http://www.asp.net/learn/dataaccess/tutorial21vb.aspx?tabid=63

    http://stackoverflow.com/questions/694921/ms-access-mdb-concurrency

    http://msdn.microsoft.com/en-us/library/aa581776.aspx (check "Create the Query Graphically, through the Query Editor") 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, May 20, 2011 3:01 AM

All replies

  • User-968982370 posted

    What type of problem your are facing, is it throwing exception?. If then please provide the exception message and stack trace if possible.

    Wednesday, May 18, 2011 6:32 AM
  • User662258659 posted

    It didn't throw any exception, it just didnt do anything, as if it dies of in the middle of the process after we concurrently click save (which run the query)

    Wednesday, May 18, 2011 7:29 AM
  • User-968982370 posted

    Better provide your code here.

    Wednesday, May 18, 2011 8:39 AM
  • User662258659 posted

    Ok, but i guess that's not much coding as the whole application was built on the use of .XSD files with Table Adaptors, we're using the BLL and DAL just like the tutorial below, in fact we referring to them.

    http://www.asp.net/data-access/tutorials/creating-a-data-access-layer-vb

    Wednesday, May 18, 2011 10:50 PM
  • User3866881 posted

    Hello:)

    In my mind, this problem is dealing with Concurrency of GridView or TableAdapter, maybe you should have a good look at this:

    http://www.asp.net/data-access/tutorials/implementing-optimistic-concurrency-cs

    Thursday, May 19, 2011 10:48 PM
  • User1867929564 posted

    Thorughly check the code and its property,if there is any lock define.
    refer this,

    http://www.asp.net/learn/dataaccess/tutorial21vb.aspx?tabid=63

    http://stackoverflow.com/questions/694921/ms-access-mdb-concurrency

    http://msdn.microsoft.com/en-us/library/aa581776.aspx (check "Create the Query Graphically, through the Query Editor") 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, May 20, 2011 3:01 AM