Under what conditions will LLBLGen send the "SET IMPLICIT_TRANSACTIONS ON" statement to a SQL Server database? Does this have anything to do with what is passed to the Adapter.StartTransaction() method?
LLBLGen Pro won't emit that statement. If you see that kind of statements, they're emitted by the SqlClient code of ADO.NET