LLBLGen Pro Support System ORM Profiler feed

cannot start profiler .net core by kakaiya

kakaiya — Thu, 14 Nov 2024 02:38:47 GMT

Otis,

I have not able to test it yet but if issue still come up for me then will let you know.

Please close this ticket for now.

cannot start profiler .net core by Otis

Otis — Tue, 12 Nov 2024 05:59:08 GMT

kakaiya wrote:

Hi Otis,

Thank you.

Did that make the data end up on the client or was the data still not arriving?

cannot start profiler .net core by kakaiya

kakaiya — Mon, 11 Nov 2024 23:22:00 GMT

Hi Otis,

Thank you.

cannot start profiler .net core by Otis

Otis — Mon, 11 Nov 2024 06:46:29 GMT

kakaiya wrote:

It is not running in UNIT test. It is runing in real code. Is there any setting to not generate and delay SQL in ORM?

For testing, could you place a Thread.Sleep(1000); right below the closing } in the using statement? The problem shouldn't occur with code running in an app, but if the app is a webapp, the thread might have ended or at least the code that has to send the data isn't available anymore (cleaned up). The reason we found when it wasn't arriving at the client was when the unit test ended and effectively all objects were cleaned up already.

(the thread.sleep(1000) is of course not useful in production, but it's meant to make sure the thread running the code isn't cleaned up before the profiler code sends the data. We use a named pipe which is fed by a thread which receives the objects to send. When the objects involved in a query (connection, dbcommand etc.) have to send data, they'll produce a message object and this is appended to a queue. The named pipe thread will empty this queue every 100ms. So if the application is terminated within this 100ms nothing will end up in the client. To my knowledge the thread dealing with this queue should stay alive as it's started as a background thread. )

cannot start profiler .net core by kakaiya

kakaiya — Mon, 11 Nov 2024 00:23:14 GMT

It is not running in UNIT test. It is runing in real code. Is there any setting to not generate and delay SQL in ORM?

cannot start profiler .net core by Otis

Otis — Sat, 09 Nov 2024 05:59:21 GMT

kakaiya wrote:

Many times it is not showing instantly any SQL in Profiler when running this code.

using (DataAccessAdapter adapter = new DataAccessAdapter()) { adapter.FetchEntityCollection(this, filterBucket, maxNumberOfItemsToReturn, sortClauses, prefetchPath, excludeIncludeFields); }

If this is in a unit test, it might be the process the query runs in ends before the actual data captured is sent to the client. I see this too in our unit tests, especially on .NET 6+. I tracked it down to that: the data is captured but as the process the capture code runs in is terminated as the test has been completed, the data is never fully sent and therefore doesn't arrive at the client

cannot start profiler .net core by kakaiya

kakaiya — Sat, 09 Nov 2024 01:57:22 GMT

Many times it is not showing instantly any SQL in Profiler when running this code.

using (DataAccessAdapter adapter = new DataAccessAdapter()) { adapter.FetchEntityCollection(this, filterBucket, maxNumberOfItemsToReturn, sortClauses, prefetchPath, excludeIncludeFields); }

Which version: v2.0.8 or 2.0.6 is it? by Findev

Findev — Sat, 12 Oct 2024 10:53:21 GMT

something in between, golden middle, ok, makes sense because why not

Which version: v2.0.8 or 2.0.6 is it? by Otis

Otis — Sat, 12 Oct 2024 05:01:22 GMT

You'll be happy to know the interceptor is v2.0.7 No I'm not kidding, we bumped the version when we updated the algorithmia references. We forgot to update the dependencies in the nuget package for algorithmia so we had to bump the version, which then became 2.0.8

Which version: v2.0.8 or 2.0.6 is it? by Findev

Findev — Fri, 11 Oct 2024 13:13:27 GMT

Hi,

zip file is named "ORMProfiler-v208-setup.zip", however, installed app has a title bar mentioning 2.0.6. And the winner is....?

Thank you!