DB function call right after opening the connection

Posts   
 
    
fdb
User
Posts: 43
Joined: 01-Jul-2008
# Posted on: 18-Nov-2009 08:34:02   

Hi, I'm using LLBLGen v2.6, Adapter mode, LINQ, .NET 3.5 and Oracle 10g.

In my application for some reasons I have created a proxy class for the LLBL data adapter. My class implements the IDataAccessAdapter interface and uses the llbl generated data adapter.

I need to call a function and pass some parameters to DBMS right after opening a new DB connection and before the execution of any other DB command. I think IDataAccessAdapter.OpenConnection() is the right place for this task but I dont know how to execute a function or stored procedure inside this method. Would you please help me in this issue?


public void OpenConnection()
{
            this.Adapter.OpenConnection();
            //How to execute a function or stored procedure here?
}

Regards, Farzad Badili

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 18-Nov-2009 09:13:48   

Please check the manual's section: Using the generated code -> Adapter -> Calling a stored procedure.