Best way to Execute database session set commands ?

Posts   
 
    
KS
User
Posts: 55
Joined: 08-Aug-2006
# Posted on: 12-Dec-2006 03:50:37   

<Environment Info> Adpater pattern LLBL Designer version 2.0.0.0 LLBLGen Pro .NET 2.0 ORM Support Classes 2.0.0.60904 .Net 2.0 VS.NET 2005 ODP.NET 10.2 </Environment Info>

I have to execute this simple set of commands immediately after opening the db connection. I am using Oracle 10gR2. <Query> alter session set NLS_COMP=ANSI; alter session set NLS_SORT=BINARY_CI; </Query>

What can be the best way, I mean which method on Adapter ? I tried looking into ExecuteActionQuery(),

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 12-Dec-2006 07:55:18   

I tried looking into ExecuteActionQuery(),

And did it work, or did you have problems with it? What exactly did you try? would you post a code snippet?

Anyway 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