none
Submitting Changes from multiple users at same time execution Problem. RRS feed

  • Question

  • hi

    our project is SL4,Entity Framework, WCF RIA Service 1.0 and we are using MVVM Pattern.

    my problem is when multiple people clicks on the submit Button at the same time. Out of 15 people, only 5 users data is saving and the remaining users are getting an exception. After waiting for 2 sec, when the remaining users clicks on the submit button, out of remaining 10 users 4 users data is saved sucessfully and remaining users are getting exception.

    In the UI, we have the fields related to all the three tables.

    Each record will have the data insert related to three Tables.

    Each user has created 3 records before clicking the Submit Button.

    The Table Relation ships is:

    Table A, Table B,Table C         

    Table A to Table B has 1 to many relation ship.

    Table A to Table C has 1 to many relation ship.

    Table B to Table C has 1 to many relation ship.

    1 : 3 records insert(WCF Ria Services Domain Context)

    2 : 3 records insert(WCF Ria Services Domain Context)

    3 : 3 records insert(WCF Ria Services Domain Context)

    -----

    14 : 3 records insert(WCF Ria Services Domain Context)

    15 : 3 records insert(WCF Ria Services Domain Context)

    '1' to '15' person click Submit button : same time.

    The Primary keys are generated by the Database. We have set the identity to increment by 1.

    Could any one tell me, how to resolve the issue? Any help is greatly appreciated. Thanks in Advance.

    Thursday, December 29, 2011 9:48 PM

All replies