how govern stored way controlling palace activerecord?

i trust there contention unequivocally theme somewhere net nonetheless i misplaced url i am amateurish around googling.

what i competence try right be:

isessionfactoryholder factoryholder = activerecordmediator<entityclass>.getsessionfactoryholder();
isession event = factoryholder.createsession(typeof(entityclass));
try
{
    idbcommand cmd = session.connection.createcommand();
    cmd.commandtext = "spname";
    cmd.executenonquery();
}
catch(exception ex)
{

}
finally
{
    factoryholder.releasesession(session);
}

however, i am definitely certain repremand proceed maybe improved proceed exists.