Hi,

Is it anyway possible to set this SQL Server parameter from within LLBLGen ? This parameter makes sure that database transactions are correctly ROLLBACKED in case of runtime-errors (e.g. time-outs) while executing statements within the scope of a transaction. Locks are then automatically lifted in case communication between client and servers no longer is present.

More info -> http://technet.microsoft.com/en-us/library/ms188792.aspx

Kind regards, Danny

Hi Danny,

I never used such flag but I see the point. If the client lost connection during a transaction, it will never get back the exception (FK constraint violatino, for instance) so you can't rollback the transaction by code and you will receive a TimeOut exception, but what happens to the current transaction? Is that the case?

Anyway, I think you can create your own version of DataAccessAdapter (XactAbortDataAccessAdapter, f.i.) to specify that hint. You can do that per instance of adapter. Here is the code snippet for NOLOCK: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=16508&StartAtMessage=0&#92356 , you just need to do it for your own hint.

Interesting--I put this in all my stored procedures that use explicit transactions, but it never occurred to me that I should be using this statement in my generated SQL that involves multiple operations (Units of Work) or operations that could time out.

Is this something that could be added as a flag to the DataAccessAdapter, or become default behavior? I can't imagine a situation where you would want SET XACT ABORT OFF.

Hi @PSandler,

I did read some blogs though where they stated that performance could decrease somewhat. Is that really the case ?

Regards, Danny

I can't see why it would have a bad effect on performance. I would have expected the other way around.

@Daelmo : thanks for the link, however it's not a Sql HINT which must be added but a SET parameter that should be inserted at the beginning. How would you do this ?

Thanks in advance !

Regards, Danny

You will need to add a method to the DataAccessAdapter.cs class similar to the following method, either by using another file (partial class) , or by deriving from it.

public static void SetArithAbortFlag(bool value)
{           SD.LLBLGen.Pro.DQE.SqlServer.DynamicQueryEngine.ArithAbortOn = value;
}

Then you will need to modify the SQL Server DQE (DynamicQueryEngine.cs) Just follow the ArithAbortOn flag, and you will know what to add and where to ad it.

Ahh...Ok ! Just inspected the DynamicQueryEngine, this looks doable....but not very maintenance-friendly. After each update of LLBLGen we have to rebuild the DynamicQueryEngine.

Isn't there another friendly way, via a partial class within the generated data-access code instead of the runtime libraries ?

greetings, Danny

Create your own class which inherits from DynamicQueryEngine, and add your code to that.

Matt

To instantiate the DQE of your own, you've to override the CreateDynamicQueryEngine method in a derived class of DataAccessAdapter