3.1,Adapter,SqlServer

I have a view with an instead of trigger. Trying to debug why the save always returns false (even though the records are getting created in the db). I think it's an issue with the identity but can't tell yet.

But I've noticed that when there are no errors in my trigger, the trace listener does log the insert statement, the parameters, etc.

But then, if the database ever throws an exception, nothing gets logged anymore so I can't tell what exactly llbl sent to the database.

Am I doing something wrong?

• We need more info about your scenario. Is it reproducible? Could you make a tiny repro solution (DDL script, LLBLGen file and a repro code)?

• What is your SQLServer version?

• Are you setting the Compatibility mode?

• What does exactly your instead-of-insert trigger?

Don't worry about the instead of trigger, I should have left that out of the post, anyways I solved that for now.

I just want to know why LLBL doesn't log the sql statements ALWAYS. Seems like if there is ever a database exception, the sql doesn't go to the trace output.

Ok. Let me test that and see where exactly is the tracing for that...

The trace info is sent when the query is built, should be able to see the trace if it is set as Verbose in your config.

Exactly which file and line is the sql logged? I will debug there too then. All I know is if the query succeeds, the sql does get logged, if I get a sql exception, the sql is not logged.

RUn the application in Debug mode, and you should see the log in the output window.

I am in debug mode. Doesn't show up in output window. Everything else basically does. I see the select statement from prior search. Then I try to save a new record. I see all this stuff getting logged about the save, MethodEnter SaveEntityCollection - Start Transaction - persisted entity info, my values are there, opeconnection, executeactionquery, ROLLBACK, RESET.

An exception is thrown.

No sql is logged to text file or output window.

Are you on verbose trace mode? :

  <system.diagnostics>
    <switches>
      <add name="SqlServerDQE" value="4" />
      <add name="ORMPersistenceExecution" value="4" />
    </switches>
  </system.diagnostics>

If it doesn't help, please post (or attach it, if it's too long) the complete trace (method enter, method exit, etc...).

I've tried with everything set to 4. However, lately, I've set ORMStateManagement back to 0

I have created another thread in the help desk with more logging so that you can review. Thanks.

I'll close this thread so we can follow up in one place.