Are you using Adapter or SelfServicing?
With adapter you may take a look at this method in DataAccessAdapter.cs
protected override IDbConnection CreateNewPhysicalConnection(string connectionString)
or with self servicing in DbUtils.cs
public static SqlConnection CreateConnection()
If you make the change there and it works the way you want then you can change the appropriate template to generate this change for you.