Hello, let me first give you my context as succinctly as possible.

Our .Net Framework application uses dotConnect for Oracle NuGet package 9.X.X.

When I joined the team and started developing for the app, I realized that certain queries took extremely long to execute (20 minutes+) but my colleagues took seconds. After debugging, it had something to do with the "serialization" of the queried data.

I requested to have a DevArt version installed in my workstation. When IT tried to, it said I had DevArt 8.X.X already installed. They uninstalled it and then installed DevArt 10.1.134 (and registered in the GAC). Suddenly, the same queries were taking seconds. Note that locally when developing, we are using DirectMode = true.

I hope I am able to draw the picture of my situation here. How do I know which version of DevArt am I using when I am developing? Our application in Production (where we're NOT using DirectMode) is slow and it might benefit by the changes that was done in my workstation.

When I tried to update my nuget package of DevArt to 10.1.134 in my project, I had errors that some of my dependencies required a higher version of EntityFramework. This adds more to my confusion. Somehow, the DevArt installed on my workstation is being used but does not require an updated version of EF.

How do I approach this? Unfortunately I won't be able to update my dependencies so easily (legacy issues, etc. etc.). Ideally, if I install DevArt 10.1.134+ on the Production server and update its connection string to do use DirectMode, I hope that the application will use this version as I have on workstation.

On the Production server, I don't see the \Program Files\Common Files\Devart\ or Program Files\Devart\dotConnect\Oracle folders, nor anything DevArt in the assemblies folder as per the Installation guide. I am guessing it is using the ORI connection with the DevArt package which is part of the project.

Thank you!