Data Access Layer Using Table Adapter Concurrency Issue

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  

Answer 1

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.

Answer 2

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)

Answer 3

User-968982370 posted

Better provide your code here.

Answer 4

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

Answer 5

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

Answer 6

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")