Not sure if this should go in this forum or another, but here goes:

We need to execute an ALTER SESSION statement when a database connection is first made using the mapper. Is there any way to do this with LLBLGen?

You should use the ExecuteActionQuery() method, here are a couple of useful threads: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=6245 http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=7165

Okay, got that. How do I execute that every time a new connection is created?

Thanks for the help!

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.

We're using SelfServing. Isn't CreateConnection supposed to return a new closed connection though?

Isn't CreateConnection supposed to return a new closed connection though?

I think what Brian ment was to open the connection inside the CreateConnection method, do your job, then close the connection and return this connection, to be used and re-opened later on by the caller.

Yeah, that's what I thought. The problem is that that will throw away the session, which we need to keep around. We're issuing an ALTER SESSION command that will change how queries are handled for the rest of the queries through that connection.

Are you sure this will happen?

As the impression I have is that: the closing and openning of the connection is done on the ADO.Net level, and that the connection is valid unless it is being disposed.

Would you please try it out?

You bet! I wasn't aware that it worked that way, but I'll give it a shot!