Devart Forums

We use dotConnect for Oracle 5.70.180 as part of a WCF service, and we are seeing some incorrect results when sending simultaneous requests to the service from multiple clients. Each request is served by several DataContext instances that are created specifically for this request and are not shared with any other requests. When using only one client everything works perfectly but even as few as 2 clients start causing issues. For example, when retrieving data from the db some dependent entities (specified through DataLoadOptions.LoadWith) are not retrieved at all (according to dbMonitor no selects are generated for them). This happens randomly for approx. 30-40% requests. Are you aware of any multi-threading issues with the simultaneous use of multiple DataContext instances? Is there any static data that they all share that is not thread-safe?

A problem similar to the one you've described was fixed in the 5.70.190 build of dotConnect for Oracle. Please try the 5.70.190 or 6.0.46 Beta build. It can be downloaded from
http://www.devart.com/dotconnect/oracle/download.html
(the trial version) or from Registered Users' Area (provided that you have an active subscription):
http://secure.devart.com/

If the problem can be reproduced with a newer version, please describe it in more details or, if possible, send us a test project so that we are able to reproduce and investigate it.